Actually, I am a newbie for the oracle database. Never though it before I start my current job. Lucky my company has a oracle expert & always help me to solve those problems. Today, just want to share some of my experience regarding the export & import for oracle. I was taught to use the […]
As a developer, most of the time you have to testing on your script output. Some how, you also need to debug into the script & checking on each variable value. In Oracle procedure, if you doesn’t having any debugging tools like sql developer. It is very difficult to trace your procedure whether is working […]
How to check MySQL database size in your server? Actually MySQL already provide the information, what you need to do is just do a simple query to retrieve the data. Below is the query : (more…)
Recently I am trying to dump a customer MySQL database to a SQL file & restore to another server. An error occur during the dump process. The error mention that one of the table in the database is crashed & repair required. Then I try to login into MySQL server & use the particular database […]
Today I am trying to restore one of MySQL dump into my development database. While I executing the mysql -uroot -p XXXX < XXXX.sql, the restoration show me the error of “ERROR 2006 (HY000) at line 3051: MySQL server has gone away“. Then I double check on the database that I restore, I found that the […]
If you enjoyed the post, make sure you subscribe to the RSS feed.
© 2024
Powered by WordPress. Design by 
Recent Comments