Error : Can't open file: 'client_details.ibd' (errno: 1)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
xs2manish
Forum Commoner
Posts: 26
Joined: Mon Aug 22, 2005 10:46 pm

Error : Can't open file: 'client_details.ibd' (errno: 1)

Post 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
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post 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.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post 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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post 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
xs2manish
Forum Commoner
Posts: 26
Joined: Mon Aug 22, 2005 10:46 pm

Post 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:
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Code: Select all

$command = "mysqldump --all tutorial -u yourusername --password=yourpassword > backup.txt";
xs2manish
Forum Commoner
Posts: 26
Joined: Mon Aug 22, 2005 10:46 pm

Post by xs2manish »

still the same error
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

Why dont use phpMyAdmin to export and import.
Post Reply