Category Archives: MySql

How to transfer WordPress from one host to another?

Let the source server be A and destination server be B Zip all the files on server A using cPanel Use SSH access of server B and pull the zipped file to the server B (Use wget) Unzip it in Public_html folder Find which database the wordpress installation was using in server A Using SSH […]

Also posted in Word Press | Tagged , , | 1 Response

How add a index key ID column to existing sql table

To add a index key table to existing sql table run ALTER TABLE tablename ADD id MEDIUMINT NOT NULL AUTO_INCREMENT KEY

Posted in MySql | Tagged , | Leave a comment

Restart mysql in Ubuntu

Debian / Ubuntu Linux then use following command: * To start mysql server: /etc/init.d/mysql start * To stop mysql server: /etc/init.d/mysql stop * To restart mysql server /etc/init.d/mysql restart

Also posted in Ubuntu | Tagged , | Leave a comment