If you get the below relation error it probably means you have spelled the table name wrong in a select statement. I was going through multiple tables tonight in a PostgreSQL database attempting to check a certain ID on a per table basis and I came across a table that provided the below error.
I wrote an article a couple weeks ago regarding a shell script to run that would provide a postgres user read only access to every table in a specific database. Tonight I was updating a over a dozen databases and needed to provide read only access to all of them to a specific user so…
**UPDATE: New article here. Its a little more complicated to create a read only database user with PostgreSQL than say using something like MySQL. You will need to grant select access on each table in the database for the read only user. Keep in mind that each time you add a new table you will…
During a recent WordPress upgrade I was performing I noticed an issue with the mysqldump of the WordPress database which was causing the actual .sql file backup of the database to not read properly. After investigating I noticed that the atpp_page_cache table from Angsuman’s Translator Plugin Pro included Blob columns that were not dumping properly…
If you have lost your ZenCart admin password it can be reset as long as you have access to PHPMyAdmin on the server or direct access to the MySQL database. If you have lost the admin password however the admin account is configured with your email address you can simply use the “Resend Password” link…
I was attempting to view the contents of what I thought was a SQLite3 database file so I needed a GUI of some sort to do so. Anyhow first I decided to install SQLite. Once I did this and created a test database to make sure to SQLite GUI was working I finally decided the…
MYSQLDUMP(1) MySQL Database System MYSQLDUMP(1) NAME mysqldump – a database backup program SYNOPSIS mysqldump [options] [db_name [tbl_name …]] DESCRIPTION The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a…
Dump MySQL database: Use the below mysqldump command syntax to dump a single database from a MySQL bash mysqldump -u root -ppassword database_name > database_staging-04-14-2008.sql Dump One Table from a MySQL DB: The below syntax will dump one MySQL table including the SQL syntax needed to drop that table if it already exists in the…
I am starting to learn ruby and am working on a test script to import some data into a MySQL database. I am using the below code found on kitebird.com to first get the MySQL connection from Ruby working. The code was producing an error which I figured might be because I installed the MySQL Ruby…