FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Help on Backing up MySQL Databases





seanooi
I'm not sure if this is the right place for this question, so please move it to it's respective section if it's not in the right one.

I'm currently using IPB 1.3 and am planning to upgrade to the newer version, IPB 2.0.4

I've read the tutorials provided by IPB and they suggest that I backup my SQL database before attempting the upgrade.

Quote:
We recommend that you back up your database by using the mysqldump command line tool:

mysqldump --opt -uusername -p databasename > databasename.sql


I was just wondering how to do that. Can anyone help?
boringest
ok you don't have root access so you can't do what they said but maybe cron job can do it, but here's how to backup your MySQL databases.

1. login to http://***.frihost.net/cpanel
2. goto Backup
3. Click on the name of your forum database
4. A popup will appear to ask where you wanna save the file.
5. Choose where you wanna save it and there you go, your backup's done.
seanooi
thank you so much!!! Laughing
gamo
seanooi wrote:
I'm not sure if this is the right place for this question, so please move it to it's respective section if it's not in the right one.

I'm currently using IPB 1.3 and am planning to upgrade to the newer version, IPB 2.0.4

I've read the tutorials provided by IPB and they suggest that I backup my SQL database before attempting the upgrade.

Quote:
We recommend that you back up your database by using the mysqldump command line tool:

mysqldump --opt -uusername -p databasename > databasename.sql


I was just wondering how to do that. Can anyone help?


Very easy, Just copy all file (the file name relevant to the database name) in the "C:\mysql\data" folder that you want to backup to another folder. Then if you'd like to use them in the future, just copy and paste them into "C:\mysql\data" again.
Related topics
Help me to Import mysql databases from web into home pc !
Help Installing MySQL on SuSE Linux using ssh
PHPBB MYSQL Database Question.
Help with mysql query
Need help understanding MySQL "Resource" type retu
Cron Jobs (AutoBackup for all MYSQL databases every 24h)
Help with dedicated server
protecting mysql databases from sql injection attacks
MySql Databases
How to import mysql databases from text files?
Need help with mySQL
Can't create or alter name of MySQL databases
mysql databases
PHP.ini and MYSQL databases
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.