Backing Up MySQL?

[Shadow X 0]

Could someone please tell me how I would back up my MySQL database? I'm using phpMyAdmin by the way. Thanks for your time.

[WeaponX 0]

Do you have cPanel for your webhost? If you are using Xisto, you have cPanel. It would probably be easier and faster if you just went into the Backups section and download the database file there.But if you still want to use phpMyAdmin for this, then go into phpMyAdmin and click on the Export link on the right window. Then select the database(s) you want to export and press the Go button at the bottom. If you want the database compressed (zipped or gzipped) you may select those options before hitting Go. That should start the download.

[Shadow X 0]

So does it download somewhere on to my harddrive? And it's on another host not Xisto.com but I am planning on making aswitch very soon. Thanks.

[yordan 10]

I expect it to do the export on the host where your database is. The export will tell you the name of the exported file. Then you probably will have to use ftp to get the file on your pc, if you want to put it on a CD-rom in order to protect it from a general failure.I did not do that part personnally yet, but I expect it do work that way.By the way, performing the backup is not at all a risky operation, you can test it without problem. Only restoring a bad backup could be risky.Regards Yordan

[Shadow X 0]

Thanks alot for the help guys, really appreciate it!

[jvizueta 0]

Try thisI can back up my database using this command:Mysqldump -u [username] -p [password] [db_name] > [backupfile.sql] on linux of course

[yordan 10]

Try this

I can back up my database using this command:

Mysqldump -u [username] -p [password] [db_name] > [backupfile.sql] on linux of course

1064326077[/snapback]

of course, you can do this only on your home linux system. You can't to that on Xisto because you don't have directly access to linux with root permissions.

[miCRoSCoPiC^eaRthLinG 0]

Not really - first on all, this command isn't restricted to Linux ONLY. mysqldump is available for Windows MySQL too and the usage syntax is the exact same as that of it's Linux counterpart.

 

Secondly - you don't need root access to carry this out. As long as you have SHELL access to your Xisto account (obtainable through separate request alongwith the reasons why you need it), you can back up your own databases using this command without a hitch.

 

As far as I know there's a slight mistake in the syntax stated here. You either add the suffix --all-databases to the command or specify individual databases using --databases suffix. Also the command doesn't start with a capitalized "M" (not that it would matter on windows, but on Linux, it surely will) An ideal command would be:

CONSOLE

shell> mysqldump -u YourUsername -pYourPassword --all-databases > myfile.sql

 

OR

 

shell> mysqldump -u YourUsername -pYourPassword --databases mydb1 mydb2 > myfile.sql

 

 

NOTE: There's a SPACE between the option -u] and YourUsername but NONE between -p and YourPassword.

 

In case you seek to back up ONLY YOUR TABLE STRUCTURE AND NOT THE DATA,

CONSOLE

shell> mysqldump -u YourUsername -pYourPassword --no-data --databases mydb1 mydb2 > myfile.sql

 

Hope thid helps

Regards,

m^e

[yordan 10]

SHELL access to your Xisto account (obtainable through separate request alongwith the reasons why you need it)

Do you think that "I want to backup my databases usign shell commands" is an accreptable reason for asking for shell access to Xisto ?Yordan

[miCRoSCoPiC^eaRthLinG 0]

Hehe - it just might However, the convincing part has to be done with OpaQue

[jipman 0]

No worries, all you need to do is just ask him and it will be done. SSH access is one of the most usefull inventions of the computer age :)btw. mse, aren't you a admin?

[sazz 0]

I use phpMyAdmin and his export feauture.