-
Hi,
I want to move my site from one hosting company to another.
I backed up all files to do so, also backup the DB.
On new hosting placed all files in place, imported all DB tables except one!
I cannot import db_options table to DB.
Everytime importing gives error on the same line:INSERT INTO
db_options(
option_id,
option_name,
option_value,
autoload) VALUES
(177, ‘userpro_activity’, ‘a:129:{i:1;a:82:{i:1393461074;a:2:{s:7:”user_id”;i:1;s:6:”status”;s:864:”<div class=”userpro-sc-img” data-key=”profilepicture”>………………………………’)
There is huge amount of data for userpro_activity option (maybe millions of data, characters and symbols, HTML tags), my server’s SQL cannot handle it. Even simple text editors cannot handle it and freeze.Any suggestions to prevent this and import table without any loss?
Also why it needs to store that much amount of data inside one table option?Thank you.
delete_option(‘userpro_activity’);
This should secure /delete activity before moving. thanks!
Solved importing.
Just increased max_allowed_packet to 64MB and problem solved.But now another problem. When I activate plugin on new host whole website show white screen of death.
I already migrated from one host to another and didn’t made that “delete_option(‘userpro_activity’);” change before importing.
Now how can I fix this white screen problem?Thank you.
What’s the php error you get? It’s possibly something that messed up during migration
Everything except UserPro works fine after migrate.
Enabled error logging and here’s the PHP error:Fatal error: Uncaught exception ‘Exception’ with message ‘The Google PHP API Client requires the CURL PHP extension’ in /home/red_dev7/public_html/wp-content/plugins/userpro/lib/google/src/apiClient.php:20 Stack trace: #0 /home/red_dev7/public_html/wp-content/plugins/userpro/functions/api.php(387): require_once() #1 [internal function]: userpro_api->load_google(”) #2 /home/red_dev7/public_html/wp-includes/plugin.php(429): call_user_func_array(Array, Array) #3 /home/red_dev7/public_html/wp-settings.php(347): do_action(‘init’) #4 /home/red_dev7/public_html/wp-config.php(93): require_once(‘/home/red_dev7/…’) #5 /home/red_dev7/public_html/wp-load.php(29): require_once(‘/home/red_dev7/…’) #6 /home/red_dev7/public_html/wp-admin/admin.php(30): require_once(‘/home/red_dev7/…’) #7 /home/red_dev7/public_html/wp-admin/plugins.php(10): require_once(‘/home/red_dev7/…’) #8 {main} thrown in /home/red_dev7/public_html/wp-content/plugins/userpro/lib/google/src/apiClient.php on line 20
The Google PHP API Client requires the CURL PHP extension
You must install cURL extension. 🙂
@Ahmed – You should add to the Docs a ‘best practice’ for migrating from local – live or old – new server environments. Like deleting user activity etc.
Might I also suggest user activity isn’t logged further back than a week or two? Because it can be a huge drain on the DB and memory to log lots of useless stuff forever.
You must be logged in to reply to this topic.