[support] Problem with recreating the site

[Jeff Greenberg]

Use command line mysqldump to create the sql file and mysql to import it. Lightening fast compared to phpmyadmin

On Nov 6, 2012, at 9:20 AM, Afan Pasalic <afan at afan.net> wrote:

> On 11/6/2012 6:45 AM, Earnie Boyd wrote:
>> On Tue, Nov 6, 2012 at 1:33 AM, Afan Pasalic <afan at afan.net> wrote:
>>> Hi to all,
>>> I had some issues with hosting company and had to leave them. But I did
>>> download all files and made mysql dump (using phpMyAdmin). The site was
>>> made with Drupa 6.
>> Using phpMyAdmin to dump a Drupal DB is not recommended procedure, you
>> may have lost some of the data due to connection timeout issues.  I
>> would have used mysqldump directly instead.
> I understand and, in general, I agree. Though, the database is small. I 
> believe no more then 1000 records in all tables, including sessions and 
> cache. :-) And I was thinking in this case phpMyAdmin will do the job, 
> and make me Import easier.
> 
>>> I tried to recreate the site on my mac mini (MAMP) but wasn't
>>> successful. I copied all Drupal files inside MAMPS/htdocs (didn't forget
>>> .htaccess) and created a database with the same name and imported mysql
>>> dump (using also phpMyAdmin).
>> What about user and password?  Check your settings.php file.
> 
> I changed the database username and password in settings.php, as stated 
> a little bit below.
> 
>>> Then made the change in settings file (line 92: $db_url =
>>> 'mysqli://root:root@localhost/mydbname';)
>> Is the password to your root user root?
> These are default values in MAMP on my local machine, my desktop (Mac 
> Mini) and it's accessible by me only. I didn't see any big reason to 
> change it. I just wanted to recreate it and localy move it from Drupal 6 
> to Drupal 7 and then move it (again) to new hosting.
> 
>>> Result is completely blank page.
>> Check the php, apache and system log files.  Maybe your memory_limit
>> needs adjusted?
> Very good idea! Why I didn't think about the basic thing?!?!?!?
> :(
> 
>>> What am I doing wrong?
>> I don't know, add a php file that simply does <?php phpinfo(); ?>.
> 
> Thanks a lot
> :)
> 
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]