Page 1 of 1
Error : Can't open file: 'client_details.ibd' (errno: 1)
Posted: Wed Sep 07, 2005 2:01 am
by xs2manish
i m trying to copy the tables from one database to another database and have the following error : Error : Can't open file: 'client_details.ibd' (errno: 1)
can anyone help me on this.
thanks in adavance
Posted: Wed Sep 07, 2005 2:10 am
by s.dot
I just did a quick google on this
Found this:
"can't open file *.idb" means that your table is not in the ibdata files, or if you are using innodb_file_per_table, you do not have the .ibd file.
The usual reason is that you have mixed ibdata files or .frm files.
Posted: Wed Sep 07, 2005 2:11 am
by anjanesh
.ibd ? What database are you using ?
AFAIK, MySQL has mainly 3 types - frm, MYD and MYI.
Try exporting the table(s) and import them to your new db.
Posted: Wed Sep 07, 2005 2:30 am
by Weirdan
anjanesh wrote:
.ibd ? What database are you using ?
Obviously (s)he's using MySQL
anjanesh wrote:
AFAIK, MySQL has mainly 3 types - frm, MYD and MYI.
You may find it intresting to read:
http://dev.mysql.com/doc/mysql/en/storage-engines.html
http://dev.mysql.com/doc/mysql/en/innodb.html
Posted: Wed Sep 07, 2005 4:49 am
by xs2manish
i m trying to use the following statements
Code: Select all
<?php
include 'library\config.php';
$command = "mysqldump --all tutorial > backup.txt";
system($command)or die('Could not connect: ' . mysql_error());
?>
and getting the following error:
Could not connect:
Posted: Wed Sep 07, 2005 5:41 am
by Chris Corbyn
Code: Select all
$command = "mysqldump --all tutorial -u yourusername --password=yourpassword > backup.txt";
Posted: Thu Sep 08, 2005 4:13 am
by xs2manish
still the same error
Posted: Thu Sep 08, 2005 4:16 am
by anjanesh
Why dont use
phpMyAdmin to export and import.