mysql dump --> via php
| From: | Wilbert Enserink | Date: | Mon, 10 Jun 2002 08:34:01 +0000 |
| Subject: | mysql dump --> via php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-101371@lists.php.net to get a copy of this message | ||
Hi all,
I have a .txt file containing a mysql dump. Normally when I would restore this dump I would go to
the mysql 'prompt' and type something like: mysql < dimpfile.txt. I would use SSH or
telnet for this.
Now I have this new problem: I cannot reach the sql pompt via SSH/telnet. Is there any other way to
create all the tables and records from the dumpfile.txt into the database on the database server??
Maybe it is possible to copy paste the sql statements into a php file which can do this?
I can then upload this php file to the webserver and perform the job.
Maybe anybody can advise me on the php code part of this solution.
Regards,
thx Wilbert Enserink
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
info@pdd.nl
-------------------------