Help with downloading/uploading mySQL tables

[wjstev0]

Can someone help me with a step by step process on how to upload and download tables using phpmyadmin.

I've been trying to move 7 tables from one database to another one. I keep getting a 500 server error every time I try. I'm obviously overlooking something.

Any help would be greatly appreciated.

[alphadesk]

Bill,

Have you tried using mySQL-Front. I find it much easier to use that myphpadmin. Runs on your local machine, not server. Here's download if you would like to try it.

http://mysqlfront.sstienemann.de/

[MelGibson]

Okay, now how can I use that to backup my database?

[bagger2000]

Im-/Export / Export tables in the menu...

[HalfaBee]

In mysql-front do

Im-Export - > Export tables

The rest is pretty self-explanitory.

Use the 'drop tables' option if you want to replace the tables when you Import the backedup DB.

HalfaBee

[MelGibson]

Awesome! thanks! So now if Powweb loses all of that information (has happened before) all I have to do is double click on that script it made for me and it will replace it?

[HalfaBee]

To reload from the backup click on the Query tag and press the folder button just above it that says "Load SQL from textfile" and press RUN button.

HalfaBee

[wjstev0]

Seems like I'm always saying thanks to Alphadesk. I gave the program a trial and it is wonderful.

It did seem to have problems with transferring tables from one databases to another when the table had over 35,000 records. I was able to work around by downloading the table to my computer as a text file. Then exporting table structure from the old to the new database and then uploading the text file.

That worked for tables with up to 50,000 records. But, when I tried to upload the table containing 74,000 records it balked no matter what I did and only downloaded 4,000 records.

After a little trial and error I was able to use a product called Navicat by PremiumSoft mySQL studio. But it costs $78 which is steep for something I'll maybe use once a year.

Sounds like I'm whining but I really did love the program and I plan on using it exclusively.

I could always use a text editor and split the table. But, it would be nice to just execute the wizard and be done. Do you have any insight on the problem with large tables?

Oh! While waiting during the hours of trying to upload these tables. I perused your sight. Wow what a great looking site and a great source for web administration.

Again I owe you


:)

[MelGibson]

Wow, this is easier than I ever would've thought it could be! Thanks to all of you!