View Single Post
  #1  
Old 03-20-2008, 10:14 PM
sdfaheem's Avatar
sdfaheem sdfaheem is offline
 
Join Date: Dec 2006
Location: AIMIM.in
Posts: 109
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01181 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete