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?
Restoring a phpMyAdmin data dump?
Moderator: General Moderators
-
Rebajas
- Forum Newbie
- Posts: 16
- Joined: Tue Aug 20, 2002 9:35 am
- Location: http://www.rebajas.co.uk/
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.
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.