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
Error : Can't open file: 'client_details.ibd' (errno: 1)
Moderator: General Moderators
I just did a quick google on this
Found 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.
Obviously (s)he's using MySQLanjanesh wrote: .ibd ? What database are you using ?
You may find it intresting to read:anjanesh wrote: AFAIK, MySQL has mainly 3 types - frm, MYD and MYI.
http://dev.mysql.com/doc/mysql/en/storage-engines.html
http://dev.mysql.com/doc/mysql/en/innodb.html
i m trying to use the following statements
and getting the following error:
Could not connect:
Code: Select all
<?php
include 'library\config.php';
$command = "mysqldump --all tutorial > backup.txt";
system($command)or die('Could not connect: ' . mysql_error());
?>Could not connect:
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Code: Select all
$command = "mysqldump --all tutorial -u yourusername --password=yourpassword > backup.txt";Why dont use phpMyAdmin to export and import.