Syndicate Posted September 10, 2012 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 108 Reputation: 6 Joined: 08/27/12 Last Seen: June 4, 2014 Share Posted September 10, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Brian Posted December 27, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted December 27, 2012 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 Quote Link to comment Share on other sites More sharing options...
Asura Posted September 10, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted September 10, 2012 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. 1 Quote Link to comment Share on other sites More sharing options...
Limestone Posted September 10, 2012 Group: Members Topic Count: 155 Topics Per Day: 0.03 Content Count: 647 Reputation: 16 Joined: 11/21/11 Last Seen: December 28, 2022 Share Posted September 10, 2012 (edited) is it ok that even the server is online, i can backup my database? Edited September 10, 2012 by Rage Quote Link to comment Share on other sites More sharing options...
Asura Posted September 12, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted September 12, 2012 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. Quote Link to comment Share on other sites More sharing options...
Jasc Posted September 16, 2012 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 270 Reputation: 20 Joined: 12/10/11 Last Seen: June 28, 2022 Share Posted September 16, 2012 I believe there is a backup script floating around for sql Quote Link to comment Share on other sites More sharing options...
Winz Posted December 20, 2012 Group: Members Topic Count: 22 Topics Per Day: 0.00 Content Count: 1479 Reputation: 172 Joined: 12/14/11 Last Seen: November 21, 2016 Share Posted December 20, 2012 or you can use Workbench / MySQL Administrator to do that. but you must open port 3306 to public first. Quote Link to comment Share on other sites More sharing options...
Asura Posted December 27, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted December 27, 2012 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. 1 Quote Link to comment Share on other sites More sharing options...
Limestone Posted December 27, 2012 Group: Members Topic Count: 155 Topics Per Day: 0.03 Content Count: 647 Reputation: 16 Joined: 11/21/11 Last Seen: December 28, 2022 Share Posted December 27, 2012 @Asura, after doing this, where is the file designated? Quote Link to comment Share on other sites More sharing options...
Winz Posted December 27, 2012 Group: Members Topic Count: 22 Topics Per Day: 0.00 Content Count: 1479 Reputation: 172 Joined: 12/14/11 Last Seen: November 21, 2016 Share Posted December 27, 2012 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! Quote Link to comment Share on other sites More sharing options...
Question
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 by VirusLink to comment
Share on other sites
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.