#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?

Options: ReplyQuote
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

Options: ReplyQuote

Sorry, only registered users may post in this forum.