Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Bill H
DevNet Resident
Posts: 1136 Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:
Post
by Bill H » Fri Jan 16, 2004 12:45 pm
Am I correct that the process using phpmyadmin is as simple as:
a) "dump" each table to my disk
b) load each resulting file into the box below the "Run SQL query/queries on database..." box.
That seems awfully simple. Can it be that simple?
AVATAr
Forum Regular
Posts: 524 Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:
Post
by AVATAr » Fri Jan 16, 2004 1:01 pm
yep... that's it!!! dump -> sql
Shendemiar
Forum Contributor
Posts: 404 Joined: Thu Jan 08, 2004 8:28 am
Post
by Shendemiar » Fri Jan 16, 2004 1:15 pm
One whole database could be in one file. No need to do it for each table.
That is at least in phpMyAdmin-2.5.4
patrikG
DevNet Master
Posts: 4235 Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK
Post
by patrikG » Fri Jan 16, 2004 1:22 pm
"Export" in phpmyadmin 2.5.4 - do make sure that the files you are creating are relatively small, otherwise you may get a script timeout error from PHP when you try uploading them again. If need be, just parcel them.