| Author |
 Topic Search  Topic Options
|
mwc2009 
Newbie
Joined: 01 September 2009
Status: Offline
Points: 8
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum Migration
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!!!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
mwc2009
Newbie
Joined: 01 September 2009
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 September 2010 at 4:22pm |
|
I looked at the upsize wizard in MS Access, but didn't see an upsize to MySQL.
|
|
mwc2009
Newbie
Joined: 01 September 2009
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
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!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
mwc2009
Newbie
Joined: 01 September 2009
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
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!!! 
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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:-
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.
|
|
|
|
mwc2009
Newbie
Joined: 01 September 2009
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
