SEO

#1 (**permalink**) 02-28-2008, 10:30 AM

hello
I am trying to backup my database and i get a strange prompt. dunno
how to do it now.
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> mysqldump -u root dbTorontoTrader <backup.sql
->

As you can see above, i get a new prompt -> . what do i do.

thanks

seede

#2 (**permalink**) 02-28-2008, 10:30 AM

Dickery1 wrote:
> hello
> I am trying to backup my database and i get a strange prompt. dunno
> how to do it now.
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 24
> Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> mysqldump -u root dbTorontoTrader <backup.sql
> ->
>
>
>
> As you can see above, i get a new prompt -> . what do i do.
>
> thanks
>
> seede
It is a 4 step process:

Step 1) Read the manual
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Step 2) Notice that the manual shows the mysqldump program command being
issued from the system shell and not from the mysql command interprter
prompt.
Step 3) Kick yourself for not reading the manual first
Step 4) Do it like the manual says.

#3 (**permalink**) 02-28-2008, 10:30 AM

On Wed, 12 Dec 2007 12:54:58 +0100, Dickery1 <junkone1@gmail.com> wrote:

> hello
> I am trying to backup my database and i get a strange prompt. dunno
> how to do it now.
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 24
> Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> mysqldump -u root dbTorontoTrader <backup.sql
> ->

mysqldump is not used from the mysql prompt, but from the shell.
so, instead of starting a mysql prompt with 'mysql -uuser -p'..etc., you
use mysqldump to dump the database ( > backup.sql), you can use mysql to
import a backup ( < backup.sql) like this:
mysql -uuser -p dbname < backup.sql

However, you can also import from the mysqlprompt:

USE dbTorontoTrader;
SOURCE '/path/to/backup.sql';
--
Rik Wasmus

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

backup challenges