Web Wiz Support and Community Forums : Export/Import MySQL Tables https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 01:20:34 +0000 Thu, 08 Mar 2007 20:16:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22137 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Export/Import MySQL Tables : Do you still have that script?...]]> https://forums.webwiz.net/export-import-mysql-tables_topic22137_post121135.html#121135 Author: w auggie h
Subject: 22137
Posted: 08 March 2007 at 8:16pm

Do you still have that script?  I am having problems with the .asp install page and was wondering if someone had the install script.  Thanks.

]]> Thu, 08 Mar 2007 20:16:19 +0000 https://forums.webwiz.net/export-import-mysql-tables_topic22137_post121135.html#121135 <![CDATA[Export/Import MySQL Tables : Never mind... I got around this...]]> https://forums.webwiz.net/export-import-mysql-tables_topic22137_post118059.html#118059 Author: SMR Group
Subject: 22137
Posted: 07 December 2006 at 11:59pm

Never mind... I got around this myself by creating an SQL script containing the contents and schema of the tables, that when run recreated those tables (with the data) on another MySQL install.]]> Thu, 07 Dec 2006 23:59:38 +0000 https://forums.webwiz.net/export-import-mysql-tables_topic22137_post118059.html#118059 <![CDATA[Export/Import MySQL Tables : boRg,I&#039;ve got a backup of...]]> https://forums.webwiz.net/export-import-mysql-tables_topic22137_post118020.html#118020 Author: SMR Group
Subject: 22137
Posted: 07 December 2006 at 12:30am

boRg,

I've got a backup of my board sitting on a second machine.  The only way I've found to copy the MySQL tables across, is to back them up as .DBF on the live board, then import them into each existing table (from the .DBF) on the standby board.

It would be a lot easier to just stop/start MySQL and cut 'n' paste the files, but if I do that the board gives me:

Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Incorrect information in file: '.\mydatabase\tblcategory.frm'

Do you know what the cause of that is, and perhaps a quick fix?  Thanks.
]]> Thu, 07 Dec 2006 00:30:23 +0000 https://forums.webwiz.net/export-import-mysql-tables_topic22137_post118020.html#118020