Importing vB Database through phpmyadmin for convertion

Kaiser

Well-known member
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.
 

Mikey

Well-known member
On a shared server :(

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.
 

Kaiser

Well-known member
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
What should I have in it?

ini_set('memory_limit', -1); ?
Create a file called php.ini with notepad, in it put something like this:

Code:
memory_limit 512M
I can't guarantee that working, but it's worth a shot.

Further reading: http://www.thewebhostinghero.com/tutorials/configuring-php-settings-in-a-shared-hosting-environment.html
Also a good read: http://thegeekdistrict.com/threads/article-hosting-why-shared-hosting-is-history-host-forums-properly.364/
Full disclosure, the last link is my site.
 

Brett Peters

Well-known member
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
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
 
Top