#1016 - Can't open file: 'booking.ibd' (errno: 1)
Posted by: redcoder (---.ipt.aol.com)
Date: June 21, 2006 12:23AM

I had created a database name "mqs_test". And I want to add another database name "mydatabase" from other machine. When I copy mydatabase to the data folder, it give me error : #1016 - Can't open file: 'booking.ibd' (errno: 1) .

What is the best way to copy database from different machine?

Re: #1016 - Can't open file: 'booking.ibd' (errno: 1)
Posted by: CyberSpatium (67.170.181.---)
Date: June 24, 2006 04:48PM

do not save or put anything in the data directory. that is where mysql saves all of your database files. you cannot just import a database from somewhere else by saving it there. you need to export that data first into some kind of format like CSV and then import it using phpmyadmin

Sorry, only registered users may post in this forum.