By stralim on

I am migrating an existing Drupal 6.x website to a new domain and hosting.
Setup the domain, uploaded the files, uploaded the SQL database file but my pages are not loading.
Any ideas on what to fix. I am not sure what to change in the .htaccess file because it looks new.
http://tinyurl.com/727zozx

⋅ Categories: Drupal 6.x

Comments

mayank-kamothi’s picture

mayank-kamothi commented

Hi,

In your site http://tinyurl.com/727zozx Clean url is not enable so your pages are not loading.

write in .htaccess file

RewriteEngine on
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]

Add this code in your .htaccess fiile than clear cache and enable clean url.

Mayank Kamothi

stralim’s picture

stralim commented

Hello Mayank,
So I just did a fresh install of drupal 6.22 and created a blank database. Now I want to be able to load the database SQL from the previous site. What should I do before I hit import?

mayank-kamothi’s picture

mayank-kamothi commented

Hi,Strailm

Your site is working fine your url issue is server related it is not from database,
Any way when you import database from one site to another site clear all cache,session and watchdog table from your database than import to new site.

Mayank Kamothi

stralim’s picture

stralim commented

Hello Mayank,
Thank you. When you say clear all cache,session and watchdog table from your database does that mean flush the table? i see within PHPmyadmin a section called table maintenance where you can do the following:
Check table
Analyze table
Repair table
Optimize table
Flush the table (FLUSH)
Or do you mean within the admin menu on the site?
Kindly,
Jennifer

stralim’s picture

stralim commented

Hello Mayank,
I cleared all cache,session and watchdog table from your database and then imported to new site and got this error message:

Error
1:14 PM
Dumping data for table `actions` -- INSERT INTO `actions` (`aid`, `type`, `callback`, `parameters`, `description`) VALUES ('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'), ('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'), ('node_make_sticky_action', 'node', 'node_make_sticky_action', '', 'Make post sticky'), ('node_make_unsticky_action', 'node', 'node_make_unsticky_action', '', 'Make post unsticky'), ('node_promote_action', 'node', 'node_promote_action', '', 'Promote post to front page'), ('node_publish_action', 'node', 'node_publish_action', '', 'Publish post'), ('node_save_action', 'node', 'node_save_action', '', 'Save post'), ('node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove post from front page'), ('node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish post'), ('user_block_ip_action', 'user', 'user_block_ip_action', '', 'Ban IP address of current user'),[...]

MySQL said:

#1062 - Duplicate entry 'comment_publish_action' for key 'PRIMARY'

mayank-kamothi’s picture

mayank-kamothi commented

You have to have an empty database to be able to import, that is why you are getting the duplicate keys.

You have to drop all the tables from the production database and then import the test database.

Mayank Kamothi

stralim’s picture

stralim commented

Thank you soo much Mayank! This is the first time I have migrated a Drupal site to a new server. And your guidance really helped me soo much. This morning is the first day it actually works! So the process was load a fresh copy of drupal, migrate your files via ftp, setup admin, empty tables and upload previous sql file.
YEAH!

If I want to run a backup I get Could not run backup because the source '' is missing. What does this mean?
Thanks Again.
Jennifer