Importing MYSQL Database Syntax $ mysql -u username -p database_name < path_to_mysql_file_here Importing existing MYSQL database with filename "wordpress.sql" stored at directory "/home/nishant/", Username is "root", terminal will prompt for asking password. $ mysql -u root -p wordpress < /home/nishant/wordpress.sql Exporting MYSQL Database Syntax $ mysqldump -p -u username database_name > path_to_mysql_file_here Exporting MYSQL database …
Showing 5 Result(s)
Introduction to Git Git is a source-code control system that allows multiple developers to work on the same project. Each developer has a copy of the repository on his workstation, and can check in changes to that repository and synchronize it with a central server. Other developers can then fetch those changes by synchronizing their …
MySQL database provides a beautiful feature of Auto Increment Column index. Database table can define its primary key as Auto Increment number and MySQL will take care of its unique value while inserting new rows. Each time you add a new row, MySQL increments the value automatically and persist it to table. But sometime you …
Following SQL statement can be used for closing comments on all pages & posts. update wp_posts set comment_status='closed'
For setting up new hostname with WordPress database is required while moving site to new hostname. For this following SQL commands. In following example we are moving site with hostname dev.example.com to hostname www.example.com.
UPDATE wp_options SET option_value = REPLACE(option_value,'http://dev.example.com','http://www.example.com');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'http://dev.example.com','http://www.example.com');
UPDATE wp_posts SET guid = REPLACE(guid,'http://dev.example.com','http://www.example.com');