Re: mySQL back up
| From: | Anas Mughal | Date: | Mon, 04 Mar 2002 16:51:50 +0000 |
| Subject: | Re: mySQL back up | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-87123@lists.php.net to get a copy of this message | ||
Well,
Run mysql with that file as input.
I work on Linux and I do something like:
mysql -ppassword DBNAME < dump.sql
Where
DBNAME is the name of the database,
dump.sql is the text file,
password is my password.
(I think I did something on Windows months and it
worked.)
--- Wilbert Enserink <wilbert@pdd.nl> wrote:
> 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
> -------------------------
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
=====
Anas Mughal
anasmughal@yahoo.com
anasmughal@hotmail.com
Tel: 973-249-6665
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com