PR,
Monday, May 13, 2002, 8:28:20 PM, you wrote:
P> Thnaks . I tried several variation and they are giving me sql syntax
P> error:
:) mysqldump is not an SQL command, it's a program for database backup.
So, you should run it from DOS prompt, f.e. if MySQL is located in
C:\mysql, it would be:
-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 11:32 AM
To: [EMAIL PROTECTED]
Subject: Re: Backing up/Creating new database
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P> I have database developed on my laptop. What is the quickest way to
P> backup the
The easiest way is simply to copy the files. Go to the directory that mysql
was installed to. There should be a subdirectory called data. Under that
should be a subdirectory named after your database. You can simply copy that
entire subdirectory to a mysql server and the database will be copied ov
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P> I have database developed on my laptop. What is the quickest way to
P> backup the database and restore it on the server? Can I restore the
P> database as empty database? Howa bout creating SQL statements based on
P> the database structure?
mysq
