HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Backing Up My Old MySQL (http://www.howtoforge.com/forums/showthread.php?t=59769)

P4rD0nM3 2nd December 2012 18:48

Backing Up My Old MySQL
 
Hey guys, I'm about to upgrade my MySQL db from source and I'm looking for ways to back up the old files before I take the plunge of compiling from source.

When I upgraded my PHP from 5.2 to 5.3 I was able to look at the ./configure command through info.php. Is there a way for me to retrieve the config params for MySQL as well?

Take note my PHP and MySQL's first installs were from RPM (Fedora 10) so most likely they were installed in different directories too with different configs.

falko 3rd December 2012 09:51

You could either take a backup of your MySQL data directory (e.g. /var/lib/mysql), or you create SQL dumps of all databases: http://www.howtoforge.com/faq/6_3_en.html


All times are GMT +2. The time now is 12:12.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.