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!
--
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
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 a
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
4 matches
Mail list logo
