Posted by R-H on November 9, 2009 at 12:04am
I've gotten stuck dumping my old database into the new Mercury configuration. Would someone please let me know where to place the old .sql file.
Also, sql is a bit of a foreign world to me and I would love to get a copy of phpmyadmin running on the build. Any help is greatly suggested. I downloaded the phpmyadmin tool but got stuck pretty early in the process.
Thank you
Comments
mysql import
Can't help you with phpmyadmin as I haven't run it in a few years. As for your database, you import it into mysql:
mysql -u root -p
(provide password)
This assumes that old.sql is an export of your DB and not just a copy of the DB files.
Hope this helps,
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com
Sorry for the confusion. So,
Sorry for the confusion.
So, since Mercury AMI creates a db by default called "pressflow", can't I skip the step of "create database db_name;"
That would leave the import command at:
mysql -u root -p -D pressflow < old.sql
It also assumes that old.sql is located at root.
Thank you!
The problem is the pressflow
The problem is the pressflow database already has data in it so the easiest way is to delete it first.
Hi ryhn, PhpMyAdmin is easy
Hi ryhn,
PhpMyAdmin is easy to install, from the command line just type "apt-get install phpmyadmin". The only confusing bit is it'll bring up a screen asking which web server you use, keep in mind that the space bar is used for selecting your web server, not the enter key. Follow the rest of the prompts and you can then access it from http://ec2-instance/phpmyadmin
I just realised when you try to access PhpMyAdmin at http://ec2-instance/phpmyadmin it'll redirect to port 8080 so just be careful of this in case the ports closed. There's no real need for this because Varnish can serve it fine, it's probably got something to do with the PhpMyAdmin config. You can always try http://ec2-instance:80/phpmyadmin
Very cool! I got it to work!
Very cool! I got it to work! I had to open port 8080, but then it worked fine.
Thank you.
FYI: I've been writing up the non-sysadmin approach to getting Mercury to work and will gladly share with everyone. A few stumbles along the way, but getting there!
Very cool! I got it to work!
Very cool! I got it to work! I had to open port 8080, but then it worked fine.
Thank you.
FYI: I've been writing up the non-sysadmin approach to getting Mercury to work and will gladly share with everyone. A few stumbles along the way, but getting there!
Does the EC2 AMI Automatically Install a DB?
Something which has been confusing me is if the EC2 AMI automatically creates a db? If so, what is the hostname and db name?
Thanks!
Well because your only
Well because your only running one server the hostname would be the local loopback address "localhost" which has an IP of 127.0.0.1. By default the database is called "pressflow" and the user "root" has access to it with no password. However keep in mind if you've installed PhpMyAdmin you should set the root database password otherwise anyone can access your database.
Old DB Imported but New Error
I was able to get the old db into mysql.
I updated settings.php to include the new db name.
Now, my sites gives me a Site Offline error message.
The IP is: http://174.129.39.116/ if you want to see.
It says "The mysqli error was: Access denied for user 'admin'@'%' to database 'lowdown'."
The site works fine if I use the old db: pressflow, which is still in mysql.
Any thoughts?
Currently your mysql username
Currently your mysql username is "admin", unless you've setup a new user called "admin" this should probably be "root". Also make sure your password is correct.
Just reloaded your site and noticed it's working :) hope you worked it out.
Nevermind
Ok, I guess I forgot to assign privileges to admin for that db. Never mind. Working now.
I am trying to do this, and
I am trying to do this, and the problem is that the 1.2 version creates the username pantheon, and the database name is pantheon_live and the password is cuvrnVRLBf.
I have tried the on the settings.php , and the default settings.php file, and even in the etc.apache2 sties available file, and I am unable to change the database name to that of my old database on my shared server, and I am unable to get it to recognize my database username and password... the one of my old database I am trying to get working with pantheon. Any help would be appreciated.
www.thecenterofthenet.com
http://cn.linkedin.com/in/roberpteatonjr
http://www.facebook.com/robertp.eaton
http://www.alamy.com/stock-photography/6A42F1A1-E40A-48FD-8C7F-FF258A401...
re: I am trying to do this, and
The easiest way to do this is to import your site to Pantheon using the hudson import job. See https://getpantheon.com/support for details.
Hope this helps,
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com