MySQL Forums
Forum List  »  Backup

Problem "Back up" VB DB
Posted by: Lovers LMP
Date: May 28, 2005 07:03AM

wel i cahnged my server hosting so i strongly need to back up my DB NOW. am really in a huirry cause i canceled the old server hosting and it gonna be down/off soon, so need to back up the DB

well when i try to backup the db by phpmyadmin it gives me this error when working in the tables "attachmentviews - post - postindex - threadviews - user - "

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/html/phpMyAdmin-2.5.6/libraries/export/sql.php on line 246

Error

SQL-query :

SELECT *
FROM `lomaximoproductions_net_-_vb`.`attachmentviews`

MySQL said:


#1016 - Can't open file: 'attachmentviews.MYD'. (errno: 145)

AND ALSO I COULD SEE THAT THOSE TABLES THAT AM HAVIN PROBLEMS ARE JUST THE ONES THAT ARE OF THE TYPE "IN USE" AND NOT LIKE ALL THE REST "MyISAM" THERE IS SOME HELP? WHAT SHOULD I DO?

PLEASE I LL BE VERY GRATEFULLY I NEED REALLY IN HURRY BACKUP MY DATABASE ATT. DJ LOVERS LMP thx IN ADVANCED TO WHO COULD HELP! :D

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem "Back up" VB DB
3117
May 28, 2005 07:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.