SQL restore question ??

[harddisk]

Hello,

Was on my way to build a second EQserver on a VM using xp sp3 ....
( actually my EQserver running on windows 7 and I'm not totally satisfied...)

I have made an "export" from my actual peq database and now I want to import the DB into the new server.... I am using Navicat for the "import"

My database size is ~ 500 MB and navicat is going in "not responding" status 10 seconds after import started.....

Is my database too big ? Do I need to change some import settings ?

thanks to the SQL "guru" who can answer me

[pfyon]

500MB can take a while to import. Give it a few minutes and see if it comes back.

[harddisk]

Last time I have wait 12 hours....lol .....without success

still in "not responding" and freezed at doors table_entry

[pfyon]

Perhaps navicat has issues with large files, or you don't have enough ram allocated to the VM.

You could try doing it from command line.

Go find mysql.exe (probably in your mysql\bin folder), navigate there through command prompt and use

mysql -u username -p databasename < path\to\import.sql

Or, you can just copy the dump to the folder containing mysql.exe and import it the same way without worrying about the path.

[harddisk]

Originally Posted by pfyon

Or, you can just copy the dump to the folder containing mysql.exe and import it the same way without worrying about the path.

I have this when I try your command line.... My syntax is wrong ?

C:\mysql\bin>mysql -u root -p peq < peqbkp.sql
Enter password: ****
ERROR 1064 (42000) at line 13: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[pfyon]

That error message is saying there's something wrong with the syntax used in the dump. Open it up (it's just a text file) and look at line 12-14 and see what's wrong.

[harddisk]

This is what I have for the first lines........ :

# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 127.0.0.1
# Database: peq
# Server version: 5.0.89-community-nt
# Server OS: Win32
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2010-01-25 19:55:44
# --------------------------------------------------------

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


#
# Database structure for database 'peq'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "peq" /*!40100 DEFAULT CHARACTER SET utf8 */;

USE "peq";


#
# Table structure for table 'aa_actions'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "aa_actions" (
"aaid" mediumint( unsigned NOT NULL default '0',
"rank" tinyint(3) unsigned NOT NULL default '0',