Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2001
Posts: 169
Member
Member
Offline
Joined: Feb 2001
Posts: 169
Hi guys, problem solved

here my feedback, hope it could be useful for someone:

After I understand that the issue was related to w3t_posts I opened the .sql with a text editor, deleted everything before w3t_posts and saved it as "PRE_W3T_POSTS.SQL", than open again the original .sql, removed everithing from the beginning to the end of w3t_posts and saved it as "POST_W3T_POSTS.SQL". Opened again and removed everything before and after w3t_posts and saved it as "W3T_POSTS.SQL".

After I created those 3 files used MySQL-Front to import all in my database. Obviously I got a problem with the w3t_posts one but MySQL-Front recorded a .err file with all operations failed.
I opened the .err and copied row by row and executed them in MySQL-Front...

DONE ! Now I have a perfect database again !

Sponsored Links
Entire Thread
Subject Posted By Posted
Trouble importing LARGE MySQL database dumps (timeouts) isaac 07/14/2004 11:11 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) isaac 07/14/2004 11:23 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) 3DSHROOM_dup1 07/15/2004 3:08 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) JoshPet 07/21/2004 8:13 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) RTeam 08/13/2004 1:35 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) bouche 08/19/2004 12:49 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) J.C. 08/24/2004 12:57 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Rutto 09/30/2004 11:51 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Rutto 10/01/2004 6:49 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) scroungr 10/02/2004 1:47 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Twisty 10/02/2004 1:51 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Rutto 10/02/2004 7:28 PM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Twisty 10/03/2004 8:08 AM
Re: Trouble importing LARGE MySQL database dumps (timeouts) Rutto 10/06/2004 9:24 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,833
Joined: January 2000
Forum Statistics
Forums63
Topics37,575
Posts293,930
Members13,823
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)