Problem With MySql Backup

[sikwel]

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

[JohnDoh]

afaik you can't back mysql by simply copying the data files, you should use mysqldump

[sikwel]

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 ?

[JohnDoh]

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.

[adumpaul]

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.