Backup Database [SOLVED]

[drmota]

Hello,

I am using Linux Ubuntu 11.04 distro with Lampp installed on to it in the /opt/ directory. I haven't changed any defaults except for some httpd.conf.

I am scared of my computer dieing one day and the whole database disappearing, so I would like to back it up to an external harddrive.

For this to be possible I need to know where the data is located. I am assuming it is either in some kind of .txt or .sql file? But where is it?

When I find it, i'll be able to cron it onto the hardrive. But then when the computer dies and it gets deleted, is it enough to just add it into where it was before?

Thank you very much in advance

[Sharley]

You can use phpMyAdmin to export your databases to an sql file and you may be able to Schedule the process from within phpMyAdmin.

How to back up most things built into XAMPP including databases:
http://www.apachefriends.org/en/faq-xam ... tml#backup

Or you could use many of the tools available like the MySQL's own command line mysqldump or even Webmin to do a useful job.

See also the XAMPP for Linux web page for 'What is where?':
http://www.apachefriends.org/en/xampp-linux.html#385

You may also find some helpful reading here:
http://www.apachefriends.org/en/faq-xampp-linux.html

Good luck.

[JonB]

@ OP

You can use phpMyAdmin - but its not a 'job' so you can't schedule it

you can use the MySQL command line tool mysqldump -
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

(that you can make a job for)

or You could learn about Webmin, the Unix/Linux system admin tool

http://www.webmin.com/rpm.html

Its has automated backups for MySQL databases built in (including FTP based)

AND FINALLY - NO -

I am assuming it is either in some kind of .txt or .sql file?

the data is really stored in the /opt/lampp/var/mysql folder in special files that are engine-specific (as in Inno db vs. MyISAM) The fiel types you mention are intermediate files used by MySQL to backup, re-instantiate, import or Create/Alter databases, Tabels, views, Inserts, triggers etc.

The ONLY correct way to store databases is with tools meant for the purpose -

Good Luck

[drmota]

thank you very much guys, works like perfect

[Sharley]

Thanks for the feed back.

Good luck.