Hi All!
Anyone know how to code the MySQL command in PHP to make the database script
download to your local hard disk, without writing 100 lines of code?
I tried the mysqldump without any luck, but I think there is an easy way to
do it, just not sure how to code it.
Thanks in advance!
--
P
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
1)Create the db in mysql: mysqladmin -u (your user name) -p (if you have
a password) create (new database name)
2)mysql -D (the name you used above) < (the text file)
Works on Unix and 2000. Is that what you mean?
-Scott
On Mon, 4 Mar 2002, Wilbert Enserink wrote:
> Hi all,
>
> I have
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 Clie
4 matches
Mail list logo
