View Full Version : [SOLVED] How do i create a backup with HeidiSQL ( World )

11-04-2013, 08:37 PM
Greetings EmuDevs Community.

Could someone please give me a guide on how to create a backup on for example the world database?

I'm not 100% sure on how to do it. I assume it's right click on world and then "Export database as SQL" ? But then what?

Thank you

Lightning Blade
11-04-2013, 08:38 PM
Right click on the world database, select export database as sql. Now under filename choose the location, at data put insert, tick on both drop and create for both database(s) and tabel(s). output: one big file

11-04-2013, 09:57 PM
Right Click the database you want to export and click on "Export Database As SQL":


After that, you will be prompt with another window called 'Table Tools'.

First, where 'Data' is, select "Insert" as its value:


Make sure your Output is, "Single SQL file":


Put in your Filename (OR path/filename): (Make sure to put .sql at the end of your filename)


And click "Export".

Now you should be exporting your database into a .sql file:


After that, you will see your sql file where ever you set it to go. Mine is in my parent directory since I didn't specify a path:


Then you're done. ;)

11-04-2013, 10:10 PM
Actually i can't set it to single SQL File.

I don't have that option.

I only have "One big File" I guess that works aswell.

11-04-2013, 10:16 PM
Lal, I guess. I just downloaded the latest 'CompiledEXE' HeidiSQL. Didn't feel like installing it. I use Navicat Lite, but I did use HeidiSQL previously. I don't find HeidiSQL user friendly at all, Navicat is the way to go. Anyway, hope it works for you.

11-04-2013, 10:20 PM
Yeah... Thanks Tommy and Lighting Blade.

11-05-2013, 07:43 AM
Yes, its called "one big file" in the older HeidiSQL versions.

Marking as solved.