Automatically dumping an SQL 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: Automatically dumping an SQL database (/showthread.php?tid=384254)
+- 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: Automatically dumping an SQL database (/showthread.php?tid=384254)
Automatically dumping an SQL database - ReneG - 11.10.2012
Is there anyway to automatically dump an SQL table to a text file daily like as to back up data?
Re: Automatically dumping an SQL database - Roel - 11.10.2012
You can use a query like this to backup tables:
Код:
SELECT * INTO Persons_Backup FROM Persons
I think you cannot use the export command inside a query, because query's are only able to deal with data inside a table, they cannot really read or write textfiles.
But I'm sure that there are scripts or tools for your windows or linux server that can make a backup(export) of your database each x time. You should ****** for that.