Hello,
i have a problem, with roundcube DB.
Mysql service is Broken, and i dont' get the Backup with dump
i save the Folder /var/lib/mysql/roundcube
but when i copy this backup on new server
mysql say roundcube.xxxxx not exist
on the folder i have 8 tables .frm
no .MYD or MYI
ps.
sorry for my english
afaik you can't back mysql by simply copying the data files, you should use mysqldump
Ok, But the old server have a problem on the service MySql
so, i can't do mysqldump because the service can't Start !
but i can read the folder /var/lib/mysql/roundcube
i dont take this for replace data in the new db ????
i think you are better off asking the mysql community about this, as i said i've never tried it but i dont think you can just move the files like that.
To backup your MySQL database using PHPMyAdmin just follow a couple of steps:
* Open phpMyAdmin.
* Select your database by clicking the database name in the list on the left of the screen.
* Click the Export link. This should bring up a new screen that says View dump of database (or something similar).
* In the Export area, click the Select All link to choose all of the tables in your database.
* In the SQL options area, click the right options.
* Click on the Save as file option and the corresponding compression option and then click the 'Go' button. A dialog box should appear prompting you to save the file locally.