where does DA store mysql dabases?

/home/mysql

There is also a link from /usr/local/mysql/data which points to the above mentioned location.
 
im in their but i cant see any of the databases for any of my accounts

[root@server100 mysql]# dir
ib_arch_log_0000000000 ib_logfile1 phil_forum test
ibdata1 mysql server100.poundhost.com.err
ib_logfile0 mysql.sock server100.poundhost.com.pid
 
I see them there, in what you posted. A database test and phil_forum

Going to /usr/local/mysql/data should be a link to wherever the data is stored.
 
Right i have all of these in a database directory

[root@server100 batcars_gallery]# dir
cpg11d_albums.frm cpg11d_comments.frm cpg11d_usergroups.frm
cpg11d_albums.MYD cpg11d_comments.MYD cpg11d_usergroups.MYD
cpg11d_albums.MYI cpg11d_comments.MYI cpg11d_usergroups.MYI
cpg11d_banned.frm cpg11d_config.frm cpg11d_users.frm
cpg11d_banned.MYD cpg11d_config.MYD cpg11d_users.MYD
cpg11d_banned.MYI cpg11d_config.MYI cpg11d_users.MYI
cpg11d_categories.frm cpg11d_pictures.frm cpg11d_votes.frm
cpg11d_categories.MYD cpg11d_pictures.MYD cpg11d_votes.MYD
cpg11d_categories.MYI cpg11d_pictures.MYI cpg11d_votes.MYI


how do I get them into 1 mysql database file :confused:
 
You could just copy the entire data directory or use the mysqldump tool to dump the databases to .sql files. The problem with .sql files is that they can be so big that MySQL will time out when trying to restore them. That is why do not not recommend making a single .sql file with all the databases.
 
On my RH9 system, the databases are located in /var/lib/mysql

Just tar the directory up to a single file. MySQL uses multiple files for each database.
 
Back
Top