By e2 on

Hi

I'm trying to do it with no success.

transferred all files from html directory with winscp
also did ecport with phpmyadmin

created database + user name

==============

mysql> create database database614;

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON database614.* TO 'user614'@'localhost' IDENTIFIED BY '123456';

then i edit settings.php file

i get an error --

the database is down or check settings.php

thanks

⋅ Categories: Drupal 6.x

Comments

pbarnett’s picture

pbarnett commented

You'd be best to use phpmyadmin or mysql to import the database you exported from your hotdrupal site.

What's happening is that Drupal recognises that settings.php has been edited, so assumes the database has been populated, i.e. it's not a new install.

However, the database is empty, as you've just created it - hence the problem.

Pete.

e2’s picture

e2 commented

thanks

I forgot to say that I did import the databse vie sql command line .

It is not an empty database.

I did it with the files from cpanel and this is not working at all.

Only ftp+ phpmyadmin -export

But again, don't see the site.

pbarnett’s picture

pbarnett commented

To be absolutely sure you've got the codebase and database copied correctly, I'd advise you to to try the following -

Log in to your hotdrupal server with SSH, then type the following commands -

tar cvfz mysite.tar.gz public_html (or wherever your Drupal install is)

mysqldump -h 127.0.0.1 --user=username --password=passwd databasename | gzip >mydata.sql.gz (change username, passwd and databasename)

You can then fetch the compressed files and recreate the installation locally.

I'm on a Linux box here, so I can keep an incremental backup of my site's codebase using

rsync -a -z --progress -S username@72.27.230.167:~/public_html/ ~/Backups (change the IP address for your hotdrupal server)

Hope this helps!

Pete.