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@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@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/ ]