Export MySQL Database - Printable Version

Export MySQL Database - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Export MySQL Database (/showthread.php?tid=528531)

Export MySQL Database - Nick.D - 28.07.2014

Is there a way to export my server's MySQL database with a bit of code in my server's gamemode? I'd like to have a sort of auto-backup system.

Re: Export MySQL Database - Blademaster680 - 28.07.2014

I dont know if that is possible. but there are 3rd party programs that allow you to run auto backups of your database.

Re: Export MySQL Database - NewerthRoleplay - 28.07.2014

Quote:

Originally Posted by Blademaster680

I dont know if that is possible. but there are 3rd party programs that allow you to run auto backups of your database.

Not having a definite answer or suggesting other possibilities but not giving answers isn't helpful to anyone.

OT: There are ways to do it via a query, consider taking a look at: http://www.tutorialspoint.com/mysql/...ase-export.htm if you have phpMyAdmin you can regularly export the tables using that. But if you want automated and are on a Linux server you can set up a cron job to run the mysqldump client, documentation for that is here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html