mySQL back up
| From: | Wilbert Enserink | Date: | Mon, 04 Mar 2002 16:01:42 +0000 |
| Subject: | mySQL back up | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-87115@lists.php.net to get a copy of this message | ||
Hi all,
I have a mySQL back up q: I have a textfile which is filled with statements
as:
----------
DROP TABLE Clients\g
CREATE TABLE Clients(
ID INT,
date BLOB,
name BLOB,
age BLOB,
PRIMARY KEY (ID)
)\g
INSERT INTO Clients VALUES ('all record data')\g
INSERT INTO Clients VALUES ('next record data')\g
..............and so on
-----------
My Q: How an I restore the tables as mentioned in my text file? Is it
possible to 'run' this file so to speak?
thx in advance!!
Wilbert
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
info@pdd.nl
-------------------------