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.