BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: Ricky1252 on August 28, 2010, 02:57:59 pm
-
ok i know iv been asking alot of weird questions D= but if i ever wanted to format my computer where would the mysql storage be? program files/mysql ? or somewhere more intresting? thanks for shairing your knowledge in advanced ^_^
-
Best option would be to backup your database regularly using MySQL dump. You can't just grab the MySQL files and restore them and expect them to work. It takes a bit more than that.
Run:
mysqldump --add-drop-table --all-databases -u username -p > mysql-backup.sql
On my Linux system I've setup a cron job to backup my databases nightly and compress the results. They then get backed up into the cloud by my backup system.
Backup is good. :D
-
sorry my video card went out xD do u think u can type in exactly what to say in cmd? i typed what u said but i couldnt quite figure out what i was doing wrong... also how do you use the file to put back in the database?
-
You really should read the documentation to understand what you're doing.
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Here's the command I run:
mysqldump --add-drop-table database_name -u mysql_username -p > database_name.sql
To restore:
mysql -u mysql_username -p database_name < database_name.sql
-
im still not sure why but it just wont dump... i just dont understand why it wont work its making me angry D= i looked at ur link and tried a few different things but it just doesnt do anything and i have no idea why....im using vs mysql vr 5.1 if that makes any difference
-
alright i finnly figured out what i was doing wrong... pritty much you have to run cmd in the proper folder i was using the mysql cmd if anyone else has this problem pritty much just make a cmd file in c:\program files\mysql\mysql server 5.1\bin then type in the command noted by glarawyn ^_^ sorry thanks for all the help glarawyn i guess i just pulled a stupid xD