Web Wiz Forums - Export/Import MySQL Tables

Print Page | Close Window

Export/Import MySQL Tables

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22137
Printed Date: 08 April 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Export/Import MySQL Tables

Posted By: SMR Group
Subject: Export/Import MySQL Tables
Date 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.

Replies:

Posted By: SMR Group
Date 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.

Posted By: w auggie h
Date 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.