[Question]Is there a Exporting guide

[Agent Orange]

Hey i was just wondering if there is a guide out there for how to export stuff from your DB and then be able to load it into a new repack/server i get i looked around and i couldn't find anything.

[stoneharry]

In Sqlyog right click on whatever you want to export, whether thats a table or the whole database, and press 'export as sql dump' or something similer. Make sure you put the settings to sql and what you want it to include (such as create, use, and delete if it's already there).
To then import it right click, create new database, name it, then right click on that database, and press restore from sql dump, target your database and execute.
The same with a table but you don't need to create it.

If your getting errors similer to "MySQL server has gone away" then you need to edit the my.ini file to allow more packets because the file your executing is to big and it's not letting you execute it for 'security' reasons.

Google the error in any case to see a easy solution.
Hope this helps.

[Agent Orange]

Thanks +rep
Edit: Iv gave out to much rep i need to wait 24 hours