How to backup my wordpress on local machine totally

Question

I have a Wordpress website published on a remote PC. I want to back it up it totally on my local CentOS PC, including posts, images, videos, etc.

Here is what I have done:

1. Download and install Wordpress on my local PC.

2. Back up the MySQL database on the remote PC using this command:

   mysqldump --user=root --password=XXXXXX --opt wordpress > wordpressBK.sql
   

3. Restore the MySQL database on my local PC using this command

   mysql --user=root --password=XXXXXXX wordpress < /home/mysqlDB/wordpressBK.sql
   

Now when I open my browser and go to http://localhost, the backup seems successful, but the URLs of topics and images in Wordpress still go to my remote Wordpress address (e.g. http://www.AAABBBCCC.com/?p=1365)

What I want is to copy everything to my local PC. How can I manually complete this backup?

If possible, I would prefer not to install plugins.

thank to the reply , after I change site URL in mysql DB ,it works here is what statement I execute

UPDATE wp_options SET option_value = replace(option_value, 'http://www.XXXXXXXX.com', 'http://192.168.3.116') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.XXXXXXXX.com','http://192.168.3.116');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.XXXXXXXX.com', 'http://192.168.3.116');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.XXXXXXXX.com','http://192.168.3.116');

Answer 1

Login to the admin (if you can) and update the site URL to your local machine address. OR (if you can't login to admin) access the database and change the URL there to the new one. Instructions on both these and one or two more can be found here: https://codex.wordpress.org/Changing_The_Site_URL

Hope that helps!