Re: why: mysqldump and mysqlimport?

2004-01-14 Thread Daniel Kasak
EP wrote: I am wondering: I can see the MySQL data files for my various databases. What technically prevents me from simply copying those files and using copies - to move my database to another file structure or server - to back-up my current db Yes, I did put my finger in the electrical socke

Re: why: mysqldump and mysqlimport?

2004-01-14 Thread Tobias Asplund
On Tue, 13 Jan 2004, EP wrote: > I am wondering: > > I can see the MySQL data files for my various databases. > > What technically prevents me from simply copying those files and using copies > - to move my database to another file structure or server > - to back-up my current db Copying will not

Re: why: mysqldump and mysqlimport?

2004-01-13 Thread Dan Nelson
In the last episode (Jan 13), EP said: > I am wondering: > > I can see the MySQL data files for my various databases. > > What technically prevents me from simply copying those files and using > copies > - to move my database to another file structure or server > - to back-up my current db Abso

why: mysqldump and mysqlimport?

2004-01-13 Thread EP
I am wondering: I can see the MySQL data files for my various databases. What technically prevents me from simply copying those files and using copies - to move my database to another file structure or server - to back-up my current db Yes, I did put my finger in the electrical socket as a kid.

Re: mysqldump and mysqlimport

2003-09-15 Thread Paul DuBois
At 4:47 PM -0400 9/15/03, Peter Koutsoulias wrote: I've been trying this for a few hours now and I'm not sure what's going on. mysqldump --host=localhost --user=root --password=mypass dbname > dbname.dump This works fine, it creates a text file with CREATE TABLE blocks and INSERT statements for ea

mysqldump and mysqlimport

2003-09-15 Thread Peter Koutsoulias
I've been trying this for a few hours now and I'm not sure what's going on. mysqldump --host=localhost --user=root --password=mypass dbname > dbname.dump This works fine, it creates a text file with CREATE TABLE blocks and INSERT statements for each table in the database. When I try to recreate

RE: Hi,All ,About mysqldump and mysqlimport

2003-03-30 Thread Cal Evans
ged into your audience -Original Message- From: Li Yang [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 8:10 PM To: mysql Subject: Hi,All ,About mysqldump and mysqlimport Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but h

Hi,All ,About mysqldump and mysqlimport

2003-03-30 Thread Li Yang
Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but how I can load the test.sql to create the same database to another server?? Thanks! Best Regards Li Yang

Re: mysqldump and mysqlimport

2002-08-21 Thread Jesse Sheidlower
e mysqldump that I could find did it mention anything > about this. > > Clearly I am doing something wrong. I searched for hours yesterday and > searched google for different was to use these commands, but couldn't find > anything other than the documentation and the s

mysqldump and mysqlimport

2002-08-21 Thread abw
d google for different was to use these commands, but couldn't find anything other than the documentation and the syntax used above. Any suggestions? Am I using mysqldump and mysqlimport correctly? I am logged on as root on both machines when I do this, and I have the right username and pas