Restoring a phpMyAdmin data dump?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rebajas
Forum Newbie
Posts: 16
Joined: Tue Aug 20, 2002 9:35 am
Location: http://www.rebajas.co.uk/

Restoring a phpMyAdmin data dump?

Post 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?
User avatar
xisle
Forum Contributor
Posts: 249
Joined: Wed Jun 25, 2003 1:53 pm

Post 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.
dekemp
Forum Newbie
Posts: 3
Joined: Fri Sep 05, 2003 5:41 am
Location: The Netherlands

Post 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.
Post Reply