Blogs
In my project, there was a requirement to set the session time out interval and i had no idea about how to implement it. Then my colleague Himanshu Seth came to rescue. This guy has already done it. All you have to do is to set the maximum time out interval in the session. Here is the sample code. declare a SESSION_TIMEOUT constant in...
In this use case we are using the jamesDump.sql stored at /home/gaurav/Desktop/jamesDump.sql file to create a new database named intelligrape. First of all we need to login to the mysql prompt. gaurav@gaurav:~$ mysql -u root -p Enter Password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection...
In this post i will try to explain how to dump a mysql database so that it can be migrated with same state.In my project i face this situation every week and thanks to dumpfiles that they save lot of time and make the process whole lot easier. What is a dumpfile ? A dumpfile is a sql script which contains the step by step...
