Results 1 to 10 of 24
-
5th Mar 2010, 04:25 PM #1OPMemberWebsite's:
unknown-bb.comBigdump
i am trying to import a database which i have moved from one host to another but i get this error while using bigdump
Stopped at the line 2626.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.
Stopped on error
how can i get round this the old server is now offline ?
any other tools pleaselenney Reviewed by lenney on . Bigdump i am trying to import a database which i have moved from one host to another but i get this error while using bigdump Stopped at the line 2626. At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos. Stopped on error how can i get round this Rating: 5http://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
-
5th Mar 2010, 04:26 PM #2Doing things differently.
MySQLDumper
Try that.
-
5th Mar 2010, 04:30 PM #3OPMemberWebsite's:
unknown-bb.comtrying that now just downloaded
http://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
-
5th Mar 2010, 04:35 PM #4MemberWebsite's:
solidservers.caYou can also ask your host, or, if you have ssh access, to load the sql dump file in through ssh. Doing so through ssh is much faster, and can handle very large databases.
Code:mysql -u username -p -D databasename < dumptextfile.sql
-
5th Mar 2010, 05:07 PM #5OPMemberWebsite's:
unknown-bb.comMySQL says:
Variable 'character_set_client' can't be set to the value of 'NULL'
Error in Query:
SET character_set_client = @saved_cs_client;
with mysqldumperhttp://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
-
5th Mar 2010, 05:09 PM #6Doing things differently.
How roughly big is the database?
-
5th Mar 2010, 05:18 PM #7OPMemberWebsite's:
unknown-bb.com150mb...
http://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
-
5th Mar 2010, 05:20 PM #8Doing things differently.
Split with this >> " SQLDumpSplitter "
into like 3/4 parts.
-
5th Mar 2010, 05:48 PM #9OPMemberWebsite's:
unknown-bb.comcheers mike ill try tommorow cba loggin on pc agen
http://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
-
5th Mar 2010, 06:26 PM #10OPMemberWebsite's:
unknown-bb.comssh gave error also
*ERROR at line 3781: Unknown command '\"'.
http://unknown-bb.com/ // http://www.cheekytunes.co.uk ONLINE RADIO
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Database Error When Restoring With Bigdump
By blow in forum Server ManagementReplies: 12Last Post: 30th Aug 2011, 02:14 PM -
How To Use Bigdump
By EsotorisK in forum Tutorials and GuidesReplies: 6Last Post: 12th Oct 2010, 11:22 AM -
bigdump error...
By anuragblr in forum Technical Help Desk SupportReplies: 2Last Post: 17th Aug 2009, 02:02 PM -
Problem with bigdump...Need help
By TinTin in forum Webmaster DiscussionReplies: 5Last Post: 21st Jul 2009, 01:33 PM -
Bigdump fails...
By GeeZus in forum Technical Help Desk SupportReplies: 8Last Post: 14th Jun 2009, 12:29 PM
themaCreator - create posts from...
Version 3.18 released. Open older version (or...