Web Wiz Forums - Forum Migration

Print Page | Close Window

Forum Migration

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=28880
Printed Date: 01 April 2026 at 5:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Forum Migration

Posted By: mwc2009
Subject: Forum Migration
Date Posted: 29 September 2010 at 6:24am

Hello,

I am in the process of trying to migrate from MS Access to MySQL & upgrade from Web Wiz Version 7.9 to the current version - I used bullzip and then had my web host import the file for me. They got back to me with the following message:

The import failed with the following error ERROR 1293 (HY000) at line 67: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UP DATE clause. The error means that you can not use TIMESTAMP with CURRENT_TIMESTAMP in the same table. You will have to make the needed adjustments within the sql file.

Does anyone know what table(s) may have generated the error? I am just starting out w/ the migration/upgrade so any information would be of great help. Thanks!!!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 29 September 2010 at 9:56am

mySQL is a very different beast to SQL Server and Access and uses very different data types. This means that the schema of the mySQL database is very different to the SQL Server and Access versions.

It would be best to go from Access to SQL Server by suing the upsize wizard in MS Access to migrate the database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mwc2009
Date Posted: 29 September 2010 at 4:22pm

I looked at the upsize wizard in MS Access, but didn't see an upsize to MySQL.

Posted By: mwc2009
Date Posted: 29 September 2010 at 9:03pm

Are you suggesting upsizing in MS Access to SQL Server (which version?) and then use another tool (which?) to migrate from SQL Server to MySQL?

Thank you very much for your help!

Posted By: WebWiz-Bruce
Date Posted: 30 September 2010 at 9:54am

What I am saying is that migrating to mySQL would be almost impossible unless you know databases very well as the schema for mySQL is very different as it does not use a relational database schema like the Access and mySQL versions, it also handles dates and other data types in a very different way.

We also tend to find that mySQL databases start to become corrupted easily when they reach around 400MB in size and so have done some conversions from mySQL to SQL Server. Due to the different database schemas these usually take our engineers around 8 hours to do and get right, and thats knowing the database schemas inside out.

If you want to move from Access to another supported database type your only real option is to move from Access to SQL Server and not mySQL.

Posted By: mwc2009
Date Posted: 30 September 2010 at 4:08pm

Perfect, thank you very much! I have a quote from my web host re: an upgrade to SQL Server. I will do that and then upsize via MS Access.

THANKS AGAIN!!! Smile

Posted By: WebWiz-Bruce
Date Posted: 30 September 2010 at 5:27pm

You could always have a look at hosting on our own network as we offer both full hosting packages with SQL Server for £4.95 per month and Web Wiz Forums Hosting packages also from £4.95 per month with SQL Server:-

http://www.webwiz.net/hosting/" rel="nofollow - http://www.webwiz.net/hosting/

We also offer a Web Wiz Forums migration service for £19.95 which includes moving across your Web Wiz Forums installation, upsizing the database to SQL Server, checking the database for any errors, and configuring the forum to work with our servers.

Posted By: mwc2009
Date Posted: 01 October 2010 at 4:54pm

Thanks for the information!

I was going in that direction and then realized, keeping things w/ my web host probably works better for me, I want all my stats in one place, SEO, etc.

Posted By: mwc2009
Date Posted: 02 October 2010 at 11:51am

Posted By: WebWiz-Bruce
Date Posted: 05 October 2010 at 11:27am

Upsizing an Access database only works on a local network. You would need to install SQL Server Express and Access on your PC, do the upsize and then backup the database and have it restored to your web hosts servers.

The only reason for this loop to keep occurring is if the files in the database folder can not be written to to record your database connection properties. This would be caused by a permission issue and you should check that the user account for the application pool your website runs under has read, write and modify permissions both on the directory itself and the files within.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting