what I do is that I use HeidiSQL, I would select the table I want to backup. Say I want to save my lootdrop table. I would right click on the table and select bulk table editor. That will bring up a table tool window. I then would select the SQL export and make sure that I have drop and create checked with replace existing data. On the left side you'll see a list of tables you can check that you want to back up on from your database. I would want to save it as "One Big File" on the output list. On the bottom left side you'll see skip tables larger than. I would click put that on "0" so it doesn't skip the one you want to save if it's bigger than what you have it as. On the icon where it looks like a floppy disk, you would click on that and it would pull up your directory in which you want to save your data in. Just give it a name. then click okay and it'll create a SQL file with all your data in it. then when you upgrade your database. just simply source your backup data into your database. It'll drop the exisiting tables on the database and replace it with the one you have. Hope that helps.
|