Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Feb 2020, 23:11
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Question Need Help Understanding DB Error..

Hey guys, I was wondering if you could help me out..

I'm moving one of my forums (VB 3.8.4) from one server to another. I exported the DB via phpmyadmin (about 500mb), and tried to import (also via phpmyadmin) to the new database on the new server.

I get this message in phpmyadmin after about a half hour of importing:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Can anyone tell me specifically what the problem here is? I really don't know much about databases and such, so I'm clueless. I've searched and searched, without any real answers.

Any help is greatly appreciated, thanks!
Reply With Quote
  #2  
Old 18 Feb 2020, 23:58
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
I wouldn't use PHPMyAdmin for exporting/importing large databases but use mysql/mysqldump to import and export databases. If you upload the .sql file to the server then your host should be able to import it properly if you don't know how to do it.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 19 Feb 2020, 02:01
shibby2 shibby2 is offline
 
Join Date: Jul 2005
How would I go about downloading a copy of the .sql file?

Thanks!
Reply With Quote
  #4  
Old 19 Feb 2020, 02:46
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
You could ask your host to dump your database on the old server -> download from old server -> upload to new server -> ask host to import the database dump.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #5  
Old 19 Feb 2020, 06:36
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Ok thanks! So that's the best way? I kind of didn't want to involve the hosts at all, since they're kind of worthless. lol
Reply With Quote
  #6  
Old 19 Feb 2020, 10:59
lange lange is offline
 
Join Date: Apr 2003
Originally Posted by shibby2 View Post
How would I go about downloading a copy of the .sql file?

Thanks!
You can try to compress your sql.

1) Backup your 500MB .sql into .sql.gz via the Backup option in cPanel and restore your .sql.gz via your new cPanel.

2) An alternative: export your .sql via PHPMyAdmin, compress the sql in zip with winrar for example, rename the extension to .sql.zip and import with PhpMyAdmin via your new cPanel.
Reply With Quote
  #7  
Old 19 Feb 2020, 13:05
In Omnibus's Avatar
In Omnibus In Omnibus is offline
 
Join Date: Apr 2010
Real name: Kris
Originally Posted by shibby2 View Post
Ok thanks! So that's the best way? I kind of didn't want to involve the hosts at all, since they're kind of worthless. lol
Use the Command Line Interface if you have one or PuTTy if you don't.

https://www.fastwebhost.in/blog/putt...for-beginners/
Reply With Quote
  #8  
Old 20 Feb 2020, 21:42
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Thanks for all the help guys!

I ended up exporting it in phpmyadmin but ticked the 'use compression (.gz)' option this time, and it seems to have imported without a problem!

Thanks again guys!
Reply With Quote
  #9  
Old 05 Mar 2020, 11:18
Hostboard's Avatar
Hostboard Hostboard is offline
 
Join Date: May 2002
Real name: Steven
I would use Adminer before PHPMyAdmin. I've had to many issues with it...
__________________
Custom Solutions for your vBulletin

Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:50.

Layout Options | Width: Wide Color: