If you have a large table with lots of records, your browser may freeze or stop working... it will even say 'Can't connect to website blah blah'

Ignore this, in fact, expect it!

I have found the best way to not freak out over what's happening is to use another browser (Opera, Firefox, Safari etc) and open up your phpmyadmin. On the first page, click on 'Show Processess'.

This will tell you what MySQL is up to, and how long it's taken so far.

Just leave it to do its thing, and come back later. Have a coffee or go for a surf.

Lets start with the 'vistats_user' table because its usually alot smaller than the 'vistats_pages' table.

Copy Users overs: INSERT INTO vistats_user SELECT user_id, user_name, user_language, user_country, user_first_visit, user_last_visit, user_computer, user_browser, user_os, user_agent, user_ip, comment  FROM vistats_user2 where robot='N' order by user_first_visit; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

Now we can move all the robots to their own table. (usually more robots than visitors)

Copy Robots overs: INSERT INTO vistats_robot SELECT user_id, user_name, user_language, user_country, user_first_visit, user_last_visit, user_computer, user_browser, user_os, user_agent, user_ip, comment  FROM vistats_user2 where robot='Y' order by user_first_visit; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

That should have taken care of both Users and Robots. Do a quick check in both the vistats_user and vistats_robot table and add up the results. They should add up to the total of your vistats_user2 table.

Now we can convert all the User Pages.

Copy User Pages overs: INSERT INTO vistats_user_pages SELECT page_user_id, page_visit_id, page_visit_order, page_start_time, page_finish_time, page_total_time, page, page_name, page_link, page_from,page_to FROM vistats_pages2, vistats_user2 where robot='N' and page_user_id=user_id order by user_first_visit; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

Now we can convert all the Robot Pages.

Copy Robot Pages overs: INSERT INTO vistats_robot_pages SELECT page_user_id, page_visit_id, page_visit_order, page_start_time, page_finish_time, page_total_time, page, page_name, page_link, page_from,page_to FROM vistats_pages2, vistats_user2 where robot='Y' and page_user_id=user_id order by user_first_visit; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

Again, do a quick check in both the vistats_user_pages and vistats_robot_pages table and add up the results. They should add up to the total of your vistats_pages2 table.

A new table I created. Lets get all the referrers from the pages table.

Copy Referrers overs: INSERT INTO vistats_referrer SELECT page_user_id, page_visit_id, 'N', page_start_time, page, page_name, page_link, page_from,'','','' FROM vistats_user_pages where page_visit_order='1' order by page_start_time; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

I have added a little extra script, to clean up all the empty feilds in converted records, such as Direct Requests, Home etc.

Clean up empty Referrers
UPDATE vistats_referrer SET referrer_page_from='Direct Request' WHERE referrer_page_from=''; UPDATE vistats_referrer SET referrer_page='Home', referrer_page_name='Home' WHERE referrer_page=''; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

 

Clean up the empty Pages, make them either 'Home' or similar
UPDATE vistats_user_pages SET page_name='Home', page='Home' WHERE page='' and page_name=''; UPDATE vistats_user_pages SET page_name=page WHERE page_name=''; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.

 

And clean up the empty Robots.
UPDATE vistats_robot SET robot_computer='Unknown' WHERE robot_computer=''; UPDATE vistats_robot SET robot_browser='Unknown' WHERE robot_browser=''; UPDATE vistats_robot SET robot_os='Unknown' WHERE robot_os=''; Copy and paste this into your 'Run SQL query/queries' box in phpmyadmin.