Hi all,
I have a live shop the customers record have over 3000 pages
It make the back end show the orders detail slowly down, since I am copy the web site to a test server and monitor what it doing when I click the orders, the mysqld eat up 50% CPU power each time I do this step...
So, now I am thinking del the older records from year 1st Jan 2006 to 31st Dec 2010. BUT KEEP ALL the RECORD from 1st Jan 2011 to now.
I can full access the server by cPanel with phpmyadmin, but I am don't know how to write the SQL command do like above.
Anyone can help me of the SQL command?
Thank you very much of your time and reply.
Bookmarks