vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Help in rectifying my database (https://vborg.vbsupport.ru/showthread.php?t=173649)

sdfaheem 03-20-2008 10:14 PM
Help in rectifying my database
 
I recently shifted servers and uploaded the folder accordingly.
My database file is around 70 mb so i am using Bigdump to restore it.
But when i attempt to restore, i get an error message:
Quote:
Error at the line 34: ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

Query: CREATE TABLE `photoplog_categories` (
`catid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediu-- Sending SELECT query...
mtext NOT NULL,
`displayorder` smallint(6) NOT NULL default '0',
`parentid` smallint(6) NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

MySQL: 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 'mediu-- Sending SELECT query... mtext NOT NULL, `displayorder` smallint(6) NOT' at line 4
I am really in a fix as i have no prior experience in handling this type of stuff(database)
Could anyone of you help me in rectifying my database or could provide me any alternative method of restoring the file on my new server?
I would be willing to provide you all the login details, only to a reputed member here.

King Kovifor 03-20-2008 10:17 PM
The easiest way for you to rectify a photoplog problem would be requesting official support from their site or the hack's thread. But I believe the problem may lie in the description field. It may require quotes around 'mediu-- sending SELECT query...'

sdfaheem 03-20-2008 10:28 PM
I tried delete the photoplog entries from the database and then i got this error:
Quote:
Error at the line 198: LOCK TABLES `vb_adv_modules` WRITE;

Query: --
`vb_adv_modules`
--
LOCK TABLES `vb_adv_modules` WRITE;

MySQL: 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 'vb_adv_modules` -- LOCK TABLES `vb_adv_modules` WRITE' at line 2
I know i have gone wrong somewhere as i do not even have the basic knowledge of how a database works.
Its very tiring you know, every time i need to wait till the 65 mb file uploads.
Even the guys at vb.com suggested me to contact photoplog, but do u think will it be of any effect?

Marco van Herwaarden 03-21-2008 09:12 AM
Code:
`description` mediu-- Sending SELECT query...
mtext NOT NULL,
Seems more BigDump related as there is rogue text inserted in the query. This should have been:
Code:
`description` mediumtext NOT NULL,
I suggest you try an alternative method instead of BigDump or contact their support.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

sdfaheem 03-21-2008 09:55 AM
I do not know if i have SSH or Telnet access, though i have a reseller hosting account, i am just new to all this and lot worried.
I tried with Bigdump, but getting errors, thinking of trying mysqldumper.
Lets see how it goes

Thanks Marco


All times are GMT. The time now is 01:23 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00952 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete