Tag Archives: db

You are here:

Home
Entries tagged with "db"

ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist

ErrorsBy alex January 19, 2011 5 Comments

Earlier today while adding a new site to a server running as a web server with many virtual hosts I ran into an error flushing the privileges after I added a new MySQL database followed by a user with only access to that new MySQL database. After a bit of investigation I realized that when…

Dump a PostgreSQL Database Without the Data

InsightsBy alex March 1, 2009 Leave a comment

Dumping a PostgreSQL database without the data is easy. Issue the below command and it will output the database table structure to a text file that can easily be imported. bash pg_dump -U postgres –schema-only DBNAME -f FILENAME.sql The above can be imported into a new database using the below syntax. psql -U postgres DBNAME…