Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. /applications/MAMP/library/bin/mysql -u root -p wordpress_db < /Applications/MAMP/htdocs/backupDB.sql
  2.  
  3. UPDATE wp_options SET option_value="http://newdomain.com" WHERE option_name="siteurl";
  4. UPDATE wp_options SET option_value="http://newdomain.com" WHERE option_name="home";
  5. UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
  6. UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com');
  7. UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com');
  8. UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
  9.  
  10. define( 'DB_NAME', 'wordpress_db' ); // only if you changed db name (don't)
  11. define( 'DB_USER', 'root' );
  12. define( 'DB_PASSWORD', 'root' );
  13. define( 'DB_HOST', 'localhost' );
  14.  
  15. <IfModule mod_rewrite.c>
  16. RewriteEngine On
  17. RewriteBase /
  18. RewriteRule ^index.php$ - [L]
  19. RewriteCond %{REQUEST_FILENAME} !-f
  20. RewriteCond %{REQUEST_FILENAME} !-d
  21. RewriteRule . /your_site/index.php [L]
  22. </IfModule>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement