Welcome to Geeklog, Anonymous Sunday, July 21 2024 @ 06:45 am EDT

Geeklog Forums

Importing dump.sql in fresh install


Status: offline

jcdeep

Forum User
Newbie
Registered: 02/05/03
Posts: 4
Hello,
I was victim like many others of this massive porn spam attack....
I decided to upgrade...
I went through a very dodgy upgrade cycle from 1.3.7 to 1.3.9...
I decided to make a fresh install
Fortunately, I have backed up my db but I can't import everything in the new created database...
I tried manually using phpMyAdmin and use SQL INSERT queries one after the other one the but some tables (e.g gl_userindex gl_userinfo gl_userprefs gl_users) did not appear to be in the same format...


Does anyone can help me to restore my old db on the new version?
Have about 500 articles and 70 users waiting for the fix

In advance, thanks
JC
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
What exactly are you trying to do?

You should not make a fresh install and then try to import tables and data from an earlier install - that won't work.

bye, Dirk
 Quote

jcdeep

Anonymous
caffeinated
It's too late my dear Dirk...I already installed 1.3.9
How can I do for restoring a db coming from gl 1.3.7 into 1.3.9?
I saw that I can restore manually a majority by copy pasting content from the sql file in the query field of PhpMyAdmin but some fields are sometimes missing in these data...
Can I reinstall 1.3.7 and retry the upgrade??
I only have a .sql dump file of my db and the public.html backup...
Please help... I am blocked!!
Cheers
JC
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by jcdeep: Can I reinstall 1.3.7 and retry the upgrade??

Keep the 1.3.9 install. Drop the database, then import your latest 1.3.7 backup and run the install script in upgrade mode on it (telling it that you're coming from 1.3.7 - there's a drop down menu for that).

That has always been the recommended way to upgrade.

bye, Dirk
 Quote

jcdeep

Anonymous
ok...I dropped databases...I imported my sql.dump in the fresh install?The import file in PhpMyAdmin SQL is not working (I guess because of the comments in the file...)
Now I get another problem :

I am blocked with 1060: Duplicate column name 'is_default'

Here is the error log file :
Tue 28 Sep 2004 12:00:53 AM CEST - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_id
Any help much appreciated!!

JC

 Quote

jcdeep

Anonymous
caffeinated
I started the installation again...now I get this:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'geeklog.rdf', 'iso-8859-1', '', 1, '0000-00-00 00:00:00', NUL

Any idea?

Thanks for your valuable advices..
JC
 Quote

Status: offline

jcdeep

Forum User
Newbie
Registered: 02/05/03
Posts: 4
hopeful
hum it looks like that my dump.sql is missing gl_comments that I might have dropped inadvertedly...
Can you send me the sql query for rebuilding gl_comments field?
It may be the cause of my trouble...thanks
JC
 Quote

Status: offline

jcdeep

Forum User
Newbie
Registered: 02/05/03
Posts: 4
I manage to fix the problem!!
My conclusion : It is better to upgrade from 1.3.7 to 1.3.8 before upgrading to 1.3.9
thx for your kind help
JC
 Quote

All times are EDT. The time is now 06:45 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content