• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Importing vB Database through phpmyadmin for convertion

Kaiser

Well-known member
#1
When trying to import the vb database through phpmyadmin I get this:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 127302282 bytes) in/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 103
after the upload went to 99%.
Any idea why?

Will be merging a vb db in my xenforo.
 

Kaiser

Well-known member
#7
try creating a php.ini and putting it in your home directory. could work, but only on a few shared hosts i know.

Other alternative is to ask your host, they can then increase the limits for you.
What should I have in it?

ini_set('memory_limit', -1); ?
 

Mikey

Well-known member
#10

Brett Peters

Well-known member
#11
I downloaded syphex dumper, trying to figure out how to use it exactly.
I am unfamiliar with that one, As for bigdump you simply edit the .php file to include your database details (similar as you would XF config)
Then upload it to your server (put in a folder and set folder permissions to 777)
Navigate your browser to /bigdump.php
 

Kaiser

Well-known member
#13
If your host allows shell access then you can use the restore command which is ideal:

http://xenforo.com/community/threads/how-to-backup-and-restore-your-forum.7213/

mysql -uUSERNAME -pPASSWORD DBNAME < /PATH/TO/backup.sql

You can also use your CPanel:

http://xenforo.com/community/threads/how-to-backup-and-restore-your-forum.7213/#post-168301
Hey Jake I already got that solved, do you mind helping me with this http://xenforo.com/community/threads/what-am-i-doing-wrong.16240/#post-214108