Page 1 of 1
Restoring a phpMyAdmin data dump?
Posted: Thu Sep 04, 2003 9:24 am
by Rebajas
I have a dump from a database using phpMyAdmin 2.5.0
The server my client wants to put it on hasn't got phpMyAdmin though - how can i restore the data?
Any ideas?
Posted: Thu Sep 04, 2003 11:02 am
by xisle
hopefully you can telnet into the machine and access MySQL.
for a CSV or tab file use
<link>
http://www.mysql.com/doc/en/LOAD_DATA.html</link>
if it is a straight SQL dump you can run the entire file as a query, or if it is large break it into smaller chunks and run those pieces as individual queries.
If you don't have command line access you will have to write it as a php script.
Posted: Fri Sep 05, 2003 5:58 am
by dekemp
Can you access your clients site through ftp ?
If yes Install PhPMyAdmin, run the upload and deinstall.
If no, can his database be accessed from outside his own side (not localhost thus) then use MySqlFront.
Hope this helps.
first option is the best.