BACK UP!

[Syndicate]

How to back my SQL at rathena?

And how to open my SQL at my VPS?

Im using asurahosting

Im really noob at this

Edited September 10, 2012 by Virus

[Brian]

mysqldump -u USERNAME -p, --password=PASSWORD DATABASE_NAME > FILE_NAME.sql

@Asura, after doing this, where is the file designated?

The file is in the same directory you ran the command from.

To specify a different directory, you can use the full file path like:

mysqldump -u USERNAME --password=PASSWORD DATABASE_NAME > /home/rathena411/backups-sql/FILE_NAME.sql

I believe there is a backup script floating around for sql

Here is one example: backup_ragnarok.sh

[Asura]

Hi Virus,

You would simply open up the Terminal or SSH command line, and then type...

mysqldump -u USERNAME -p, --password=PASSWORD DATABASE_NAME > FILE_NAME.sql

Replace all capitalized words with the proper values. This question has actually been asked a few times on rAthena.org; doing a search would have brought you the answer quicker.

[Limestone]

is it ok that even the server is online, i can backup my database?

Edited September 10, 2012 by Rage

[Asura]

Hi Rage,

Yes, it's fine to do that; though once your database becomes a fairly large size, it'd be recommended that you switch MySQL from MyISAM to InnoDB.

[Jasc]

I believe there is a backup script floating around for sql

[Winz]

or you can use Workbench / MySQL Administrator to do that. but you must open port 3306 to public first.

[Asura]

or you can use Workbench / MySQL Administrator to do that. but you must open port 3306 to public first.

Hi Winz,

This would actually be one of the worst ways to take a SQL backup, because it's impractical to grab a several hundred MB SQL backup with high chance of failure. It'd be better to take the backup on the VPS, tar/zip it, and then download it using SFTP... it would be way faster.

[Limestone]

@Asura, after doing this, where is the file designated?

[Winz]

or you can use Workbench / MySQL Administrator to do that. but you must open port 3306 to public first.

Hi Winz,

This would actually be one of the worst ways to take a SQL backup, because it's impractical to grab a several hundred MB SQL backup with high chance of failure. It'd be better to take the backup on the VPS, tar/zip it, and then download it using SFTP... it would be way faster.

Hi Asura, yes, it is, I admit it. otherwise, this is the only way I use since guides in the internet vary and this way allows me to be sure that the data are being taken. I'm a noob in SQL backup.

Have a nice day!