Tag Info

Hot answers tagged

3

EBS snapshots are atomic, they're a point-in-time. This means that for PostgreSQL, so long as all the datadir including WAL, and all tablespaces are in the same EBS volume, starting from a snapshot is equivalent to starting after an unclean shutdown (crash), which PostgreSQL is designed to do reliably every time. You do not need to stop I/O to the volume to ...


3

Amazon's packages for PostgreSQL will upgrade from 9.1 to 9.2 as if that was a normal minor update. It isn't; see the PostgreSQL version policy, which makes it clear that the major version is "x.y", eg "9.1", "9.2", etc. This version policy may be weird and perhaps unwise, but it's also widely understood and something you would expect packagers to ...


2

You can pull this off using mysqldump. Here the catch: You cannot ship the data because there may be a cost associated with shipping the data. For this example, let's says you want to rename mydb to ourdb STEP 01 : Create the new database mysql> CREATE DATABASE ourdb; STEP 02 : Get schema without the triggers mysqldump -hrdshost -uuser -ppassword -d ...


2

you can rename the database using the following command but make sure to take backup first CREATE database new_db_name; RENAME TABLE db_name.table1 TO new_db_name, db_name.table2 TO new_db_name; DROP database db_name; references: http://www.rndblog.com/how-to-rename-a-database-in-mysql/ http://stackoverflow.com/questions/12190000/rename-mysql-database


2

Your problem has nothing to do with missing databases. You real problem stems directly from the way you logged in to MySQL. First, look at your comment SHOW DATABASES; => information_schema, test. SELECT USER(); => root@localhost SELECT CURRENT_USER(); => @localhost SHOW GRANTS; => GRANT USAGE ON *.* TO ''@'localhost' Note the difference ...



Only top voted, non community-wiki answers of a minimum length are eligible