I am using mysql 4.1
I tried this method, the VB recommended
mysqldump --opt -Q -h servername -u dbusername -p databasename > /path/to/backupname.sql
which translates to
mysqldump --opt -Q -h mysqlhost -uu70249929 -ptest d60233538 > back/vbtest.sql
and this one also
mysqldump --opt -Q -h myslhost -u u70249929 -ptest d60233538 > back/vbtest.sql. (with space at the user)
i get this error
Got error: 1044: Access denied for user 'u70249929'@'%' to database 'd60233538' when using LOCK TABLES
This is the Webhost recommended it works
mysqldump --force --quick --quote-names -h mysqlhost -u u70249929 -ptest d60233538 > dbBackupFile.sql
but i always get this error, I mean Always
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_phrase' at row: 5128
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_post' at row: 108
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_post_parsed' at row: 209
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_postindex' at row: 39967
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_template' at row: 210
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'vb3_word' at row: 25963
Is it a problem? help, my database has no backup since day one ... I cant seem to have a backup method working.
If the Webhost method will do, then i will use it, pls give recoomendations
I tried this method, the VB recommended
mysqldump --opt -Q -h servername -u dbusername -p databasename > /path/to/backupname.sql
which translates to
mysqldump --opt -Q -h mysqlhost -uu70249929 -ptest d60233538 > back/vbtest.sql
and this one also
mysqldump --opt -Q -h myslhost -u u70249929 -ptest d60233538 > back/vbtest.sql. (with space at the user)
i get this error
Got error: 1044: Access denied for user 'u70249929'@'%' to database 'd60233538' when using LOCK TABLES
This is the Webhost recommended it works
mysqldump --force --quick --quote-names -h mysqlhost -u u70249929 -ptest d60233538 > dbBackupFile.sql
but i always get this error, I mean Always
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_phrase' at row: 5128
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_post' at row: 108
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_post_parsed' at row: 209
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_postindex' at row: 39967
mysqldump: Error 1053: Server shutdown in progress when dumping table 'vb3_template' at row: 210
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'vb3_word' at row: 25963
Is it a problem? help, my database has no backup since day one ... I cant seem to have a backup method working.
If the Webhost method will do, then i will use it, pls give recoomendations
Comment