Database

Login to Mysql with an authorized user. > mysql -u root -p If more than one database exists, it can be listed with the following command. > show databeses; Then …

Error: During an RMAN backup, we may receive the following errors. ORA-00245: check file backup operation failed, we receive a warning. RMAN-08132: WARNING: …

Error: When clients attempt to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from the client”. …

We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I begin the redesign procedure, I need to make the accompanying basic cautioning: You …

The status allows you to see various stats on the MySQL daemon. To get to your MySQL shell, type the following command at your shell: [icezip@saturn ~/]$ mysql …

Do you have your own database? How would you like to know how many entries you have in your database from a PHP page? Well its easy, I am going to show you a …

This is the beginning of a series where I will work through the basic Mysql commands that you will need to manage a database. These commands are covered in this …

MysqlDump can be used for many different reasons. For one, you can use mysqldump to backup the data in your MySql DataBase. Here is what mysqldumpdoes. …

Databases grow over time, and sometimes it’s necessary to add disk space to a server to accommodate that growth. Fortunately, moving your database is a fairly …

It’s time to fix some common errors in your blog. In this blog post, we are going to discuss common structured data errors. You can use Google webmaster tools …

Recently we faced a situation where the server hosting our Analysis Services ran out of the space on the primary C drive. After looking at the files stored on C …

We as database developers, many times have to export data into csv files and send them across to the Business users. The data the needs to be exported can be a …