Hi,

I want to copy some databases to a new server and I have tried to backup
my databases with mysqldump in the old server, then copy those files to
the new server and recover them with mysqldump again. The problem is
that when doing,

>mysqldump -u root -p mydb < mydb_backup.sql

the message that appears is

-- MySQL dump 10.11
--
-- Host: localhost Database: dbcontrol
-- ------------------------------------------------------
-- Server version 5.0.45
/..../
-- Dump completed on 2007-11-28 11:13:13

But when entering mysql in the new server, no table has been restored
although it says that dump has been completed. The old server version is
5.0.21 with mysqldump 10.10. Any idea how to solve this and copy my
databases properly?

Thanks for your help.

Hi ,

U Can try using this option.

Login into database

Type as :-

\. /tmp/mydb_backup.sql

Hope this will help you out.



-----Original Message-----
From: Alicia Amadoz [mailto:Alicia.Amadoz@uv.es]
Sent: Wednesday, November 28, 2007 5:27 PM
To: mysql@lists.mysql.com
Subject: Problem recovering from mysqldump

Hi,

I want to copy some databases to a new server and I have tried to backup
my databases with mysqldump in the old server, then copy those files to
the new server and recover them with mysqldump again. The problem is
that when doing,

>mysqldump -u root -p mydb < mydb_backup.sql

the message that appears is

-- MySQL dump 10.11
--
-- Host: localhost Database: dbcontrol
-- ------------------------------------------------------
-- Server version 5.0.45
/..../
-- Dump completed on 2007-11-28 11:13:13

But when entering mysql in the new server, no table has been restored
although it says that dump has been completed. The old server version is
5.0.21 with mysqldump 10.10. Any idea how to solve this and copy my
databases properly?

Thanks for your help.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=d...parikh@eds.com

On Wed, 28 Nov 2007 12:57:25 +0100 (CET)
"Alicia Amadoz"<Alicia.Amadoz@uv.es> wrote:

> Hi,
>
> I want to copy some databases to a new server and I have tried to
> backup my databases with mysqldump in the old server, then copy those
> files to the new server and recover them with mysqldump again. The
> problem is that when doing,
>
> >mysqldump -u root -p mydb < mydb_backup.sql
>
> the message that appears is
>
> -- MySQL dump 10.11

If mydb_backup.sql is the dump file, try:

mysql -u root -p mydb < mydb_backup.sql

mydb_backup.sql is populated with sql statements that need to be ran
using mysql.

------
_|_
(_| |