Paid affiliate hosting advertisement
Migrating Drupal 6x from Localhost to Hostgator
Hi everyone,
I've been banging my head against my desk for a few days now. I'm trying to move my localhost/drupal site to hostgator, but whenever I transfer my site I get a list of mysql errors (posted below). I've reloaded everything, I've reinstalled my database a few times, I've checked my settings.php file, and even checked it with a hostgator service tech about any possible solutions they might have (none). I have also checked my php mem limit. So I'm just wondering why I keep getting these errors:
I've replaced my username with (username)
(sorry this is going to be long)
Warning: Table '(username)_drupalbry.(username)access' doesn't exist query: SELECT 1 FROM (username)access WHERE type = 'host' AND LOWER('xx.xxxx.xxx.xxx') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /home/(username)/public_html/includes/database.mysql.inc on line 128
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 1009
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 1009
Warning: Table '(username)_drupalbry.(username)cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM (username)cache WHERE cid = 'variables' in /home/(username)/public_html/includes/database.mysql.inc on line 128
Warning: Table '(username)_drupalbry.(username)variable' doesn't exist query: SELECT * FROM (username)variable in /home/(username)/public_html/includes/database.mysql.inc on line 128
Warning: Table '(username)_drupalbry.(username)cache' doesn't exist query: UPDATE (username)cache SET data = '', created = 1237513009, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /home/(username)/public_html/includes/database.mysql.inc on line 128
Warning: Table '(username)_drupalbry.(username)system' doesn't exist query: SELECT name, filename, throttle FROM (username)system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /home/(username)/public_html/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 610
Warning: Cannot modify header information - headers already sent by (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 611
Warning: Cannot modify header information - headers already sent by (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 612
Warning: Cannot modify header information - headers already sent by (output started at /home/(username)/public_html/includes/database.mysql.inc:128) in /home/(username)/public_html/includes/bootstrap.inc on line 613
Warning: Table '(username)_drupalbry.(username)url_alias' doesn't exist query: SELECT COUNT(pid) FROM (username)url_alias in /home/(username)/public_html/includes/database.mysql.inc on line 128I've been looking for a while through the postings here and through google, but haven't recognized anything that would help. If anyone could even just point me in the right direction.... Sorry if this is a common question and I just didn't realize, but I'm thinking I'll just have to re-install it and copy my styles and modules over... hopefully not!!!
Thanks to anyone who actually looked through this!! haha
how u create the "db" and
how u create the "db" and "tables" in the Mysql on the host?
double check the name of the db and the names of the tables.
may be
1. wrong db name
2. wrong table name
3. missing table(s)
is this table exist : (username)_drupalbry.(username)access ??
We go the drupal way. How about you?
http://www.drupalway.com
I create a new database, then
I create a new database, then import the one from my testing site.
I have checked the name & the table names, and they look to be the same except for the prefix on each table has to change. the access table does exist too...
I will triple check just in case though...
btw, Thanks for the help!
--Bry
Are you using clean_urls?
I was having the same problem as you, i think is because the use of clean_urls , you should read this http://drupal.org/node/15365 and this one to take the clean_urls off http://drupal.org/node/5590
I hope it helps
Wherever we are, iis the right place, at the right time.
Enjoy life!!!
clear all cache data
hi, i found clearing the cache helped me.... just do in the database... or browse to /user... login and goto /admin/settings/performance and clear cached data.
Mojoinst