Import a backup SQL file

[Sandile]

Recently my DB got ****ed up somehow, (It got deleted). As the whole DB got deleted mysql stop working because the necessary DB (mysql) was also deleted. So I had to reinstall Mysql and get a new DB. Now of course I made some backups of the DB so my work wouldn't just be removed. But my world backup is around 260mb and I can't find any way to import a file of that size. The DB was dumped by Navicat if that helps.
I have tried some script called bigdump but the file is still to big for it. I have tried some mysql program called mysqladministrator. I have tried phpmyadmin. I have tried SQLyog. Neither of these worked. So if anyone out there got any way to import huuuuuge sql files into a db, please share...

Red = bad

[Algorithm]

Change that in my.ini in MYSQL folder

[mysqld]
max_allowed_packet=200M <-----

[Sandile]

No, its not that the data is to big. No program can handle a SQL file that big. The program freezes. I have already changed max allowed packet.

What program do you use when you are importing your world db backup? (asking everyone)

[Dythzer]

Have you actually tried using the MySQL CLI? GUIs like navicat are just useful for quick and small edits in db tables, not for importing or dumping databases (unless they are really small or if you like huge files).

In windows: start mysql cli/console, type your password and then:
use <database>
source <path to file>

Example:
use mangos
source "C:\Backup.sql"

[Algorithm]

No, its not that the data is to big. No program can handle a SQL file that big. The program freezes. I have already changed max allowed packet.

What program do you use when you are importing your world db backup? (asking everyone)

lol.... my character database is 1.5 GB ... and i never ever had any problems importing it.

And i use Heidi SQL or Sqlyog Ent

[Sandile]

Have you actually tried using the MySQL CLI? GUIs like navicat are just useful for quick and small edits in db tables, not for importing or dumping databases (unless they are really small or if you like huge files).

In windows: start mysql cli/console, type your password and then:
use <database>
source <path to file>

Example:
use mangos
source "C:\Backup.sql"

Tried to do that. I wrote
start mysql cli/console in my command shell and it poped up a new window that instantly closed down. I could see what the text was by repetedly poping up the window the text was:

Error 1049 [4200]: Unknown Database cli/console

Do I need to download something called Mysql cli or what? and by mysql cli do you mean mysql client? because that one is abit ****ed up.
I'm just gona restart my comp to check if something happends.

[Dythzer]

Do I need to download something called Mysql cli or what? and by mysql cli do you mean mysql client? because that one is abit ****ed up.
I'm just gona restart my comp to check if something happends.

MySQL CLI = Command Line Interface, the console where you type all commands.

In case you don't know how to start it, open up the start menu and then go to "All programs -> MySQL -> MySQL Server 5.x -> MySQL Command Line Client" if you're using XP.
In vista/windows 7, just type "mysql" in the searchbox and you will see it.

[Sandile]

Okay I finally got it to work. After like 15 tries. Thank you very much for your help. +Rep