Suggestion; Mysql upload support

Comments on existing version & Suggestions for future versions. If you want a new feature suggest it here. Discussions about beta versions also come in this section.
Post Reply
watchout

Suggestion; Mysql upload support

Post by watchout »

First off I would like to thank you for the great software u have made..

It's exactly what I was looking.. Although I like to make one suggestion;

Would it be possible to implent some sort of feature which enables me to add new entry's straight into a Mysql database.. So if I make a new entry and click export it can upload the new entry's right away into the database.. That way it would be more easily to update my list online..

Let me know what u think of it ;)

Thanks man
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

I wanted to do that, but MySQL most serveurs refuse connections from other servers (even non-free servers)
watchout

Post by watchout »

Hmm.. Never thought of that really..

Well.. this way is also alright though.. Thanks for the speedy reply :)
El Ga

Post by El Ga »

It would be a VERY NICE feature, to update online MySQL databases directly from te program...

I don't understand how can the program Dreamweaver MX work with databases, if you say the servers refuse te conection.... :/
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

Maybe that some expensive or individual server accept it, but the few pay host that I know (those that are cheap, e.g. the one I use) do not accept that, probably because they are server where multiple accounts share the same machine.
El Ga

Post by El Ga »

I had that kind of problem with DreamWeaver.... I had to change the user's restriction, in order to give permission to enter the database from somewhere else than "localhost"...

And now, I can work with my MySQL database from DreamWeaver...

If you ever want to test this option, let me know (prv@009.com.ar), since I could help you test this feature with diferent user's permissions...

C.ya!!
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

You have to change that on the server I guess ?
Actually to test it I may simply install a MySQL server on a PC on the local network.
I will see if this is easy to add in a future version.
watchout

Post by watchout »

After a bit of thinking and coming back to this thread I had a little idea.. What about making a php script and upping that on the server where the mysql database is.. Then u upload the info through the script. I am not really familiar with PHP but I guess something like that could be managed.. I'll see if I can find someone who is more into php scripting :)
watchout

Post by watchout »

To those who didn't totally understood what I meant above:

Ant Movie Catalog --> php script --> mysql database

So.. Then the mysql database excepts the connection from the php script while u are sending the info from ur own pc.. (It's like logging into the mysql database through the script)

Hope this helps it a bit better to understand what I mean :D
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

I do not really see what's the advantage of this solution
If you upload the SQL scrit with PHPMyAdmin it will work, no need to write a script for that ;)
watchout

Post by watchout »

uhm.. U don't need to go through the hassle of uploading it through phpmyadmin.. U only need to hit "upload" in AMC and ur list is updated...
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

It could be done in two times :
- upload the script (php + sql)
- call the php script
But for that I'll have to add FTP support to the program
Not really difficult but it will make the program even bigger :(
I will see in a future version, I should try to make a "plugins" system
watchout

Post by watchout »

A "plugins" system would be excellent.. So only the people who like to use this feature have to download/use it.. :grinking:
zion
Posts: 19
Joined: 2002-05-30 14:35:24
Location: Nivelles, Belgium

Post by zion »

antp wrote:I wanted to do that, but MySQL most serveurs refuse connections from other servers (even non-free servers)
http://www.sql-gratuit.com/

:hihi:
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

zion wrote:
antp wrote:I wanted to do that, but MySQL most serveurs refuse connections from other servers (even non-free servers)
http://www.sql-gratuit.com/

:hihi:
It did not exist when I wrote this post :p
zion
Posts: 19
Joined: 2002-05-30 14:35:24
Location: Nivelles, Belgium

Post by zion »

Now it does :innocent:
Wermine

How about FTP?

Post by Wermine »

I don't know is this what you think, but internal ftp would be nice. I use only html and I have to frist export database to html file and then open my ftp program and upload it into net. If Ant Movie Catalog would have internal ftp, which uploads while it exports, it would be nice. Thanks.
antp
Site Admin
Posts: 9630
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

It is planned since long time, but I still haven't added it :/
Post Reply