Restore Db

[Albert Kao]

I use SQLyog Community v8.01 on Windows XP to dump a db on mysql on solaris to the test.java file.

I use SQLyog Community v8.71 on Windows 7 to restore db from the test.java to mysql-essential-5.1.53-winx64.

The restore is completed ok but no db is created.

Please help.

Thanks.

test.java look ok:

Code:

/*
SQLyog Community Edition- MySQL GUI v8.01
MySQL – 5.0.41-log : Database – test
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test`;

/*Table structure for table `CDATA` */

DROP TABLE IF EXISTS `CDATA`;

CREATE TABLE `CDATA` (
`cfid` varchar(64) default NULL,
`app` varchar(64) default NULL,
`data` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `CDATA` */
…

[peterlaursen]

Please look at this: 

Code:

CREATE DATABASE /*!32312 [b]IF NOT EXISTS[/b]*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;

Probably the database already has a `test` database.  If it has nothing important you may drop it before running the import job. Or manually edit the dump and replace all instances of `test`with `test_new`or whatever.

[Author]

Posts