Error 2013 went away when I typed "create database sfg" at the mysql client prompt before loading the dump. I have asked this before. Let me try again. How can I take the dump of a database db1 and load it into another database db2 on the same host? If this looks like a backup operation, please note that I am only interested in preserving the schema without the data. Is it possible to just transfer the schema to a new database? Thanks
murthy gandikota <[EMAIL PROTECTED]> wrote: I can't get mysqldump to work. I typed mysql -uuser -ppassword sfg < sfgdump.sql The error is ERROR 2013 (HY000): Lost connection to MySQL server during query phpninja wrote: I prefer the mysqldump utility for transfering data. Its pretty fast (if your tables are not huge gigabytes in size).. and preserves you tables/data just as they were when you moved them. As far as I know, copying data on the filesystem level in mysql does not work. You cannot copy data files somewhere else and change the path and expect it to work. Use mysqldump or somthing similar to recreate your tables and move them. HTH. -phpninja -----Original Message----- From: Dan Buettner [*mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 8:12 AM To: murthy gandikota Cc: mysql@lists.mysql.com Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1) Murthy, doing some quick reading on InnoDB table definitions, it appears that MySQL itself keeps some info in the .frm file, while InnoDB keeps some info within the tablespace. While you can easily move MyISAM table files about amongst MySQL database directories (mind you stop the server and that MySQL access permissions won't follow), the same appears to not be true for InnoDB. I'm not sure what the best way to move or copy an InnoDB table or tables from one database to another is ... anyone? Dan murthy gandikota wrote: > Hi Dan > The table was never dropped. I removed the agent.frm file and tried. Here is the output: > mysql> desc agent; > ERROR 1146 (42S02): Table 'sfgn.agent' doesn't exist > > > Dan Buettner wrote: > Is the 'agent' table a current table, or one that got dropped at some point? > > See > *http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict* > .html The last half seems relevant - it's pointing you to removing the > .frm file manually. Personally, I'd mv it and not rm it. > > Dan > > > murthy gandikota wrote: >> Hi Dan >> I've set the permissions to 777 for all the files and directories. >> Basically I did chmod -R 777 sfgnew. Also changed the ownership to >> mysql using chown -R mysql:mysql sfgnew. >> >> Thanks! >> >> */Dan Buettner /* wrote: >> >> Murthy, do you have appropriate permissions (777 works, or 775/770 if >> owned by mysql user) on your new directory ('sfgnew')? If you don't >> have execute permission for the mysql user on that dir, MySQL can't >> list the contents ... >> >> Dan >> >> murthy gandikota wrote: >>> I'm getting the following error >>> ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1) >>> >>> This is the output from mysqld >>> >>> 060613 19:59:34 InnoDB error: >>> Cannot find table sfgnew/agent from the internal data dictionary of >>> InnoDB though the .frm file for the table exists. Maybe you have >>> deleted and recreated InnoDB data files but have forgotten to delete >>> the corresponding .frm files of InnoDB tables, or you have moved >>> .frm files to another database? >>> Look from section 15.1 of *http://www.innodb.com/ibman.html*how you >>> can resolve the problem >>> >>> >>> Can anyone please help me figure this out? >>> Here are some pertinent facts: >>> a) stopped mysqld >>> b) copied files from sfg to sfgnew in the var directory >>> c) set the permissions to 777 (read, write, execute) for all the >> files in sfgnew >>> d) restarted mysqld >>> >>> Murthy >> -- >> MySQL General Mailing List >> For list archives: *http://lists.mysql.com/mysql*To unsubscribe: >> *http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> __________________________________________________ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> *http://mail.yahoo.com* >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > *http://mail.yahoo.com* -- MySQL General Mailing List For list archives: *http://lists.mysql.com/mysql* __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com