Tag: mysql
How to check and change innodb buffer pool size in mysql database
- 0
The InnoDB buffer pool size in MySQL determines how much memory is allocated to store frequently accessed data and indexes. To check and change it, follow these steps: 1. Check Current InnoDB Buffer Pool Size a. Log in to MySQL mysql -u root -p b. Run the Following Query …
Read More
Setting of Auto backup of Mysql database in a laravel project
- 0
When we work on any database project, it’s always good to set up autoback of the database on daily basis. We can set up a cron job for backing up a MySQL database in a Laravel project, follow these steps: 1. Create a Laravel Artisan Command Run the following command to create a custom Artisan…
Read MoreHow to import an SQL file using the command line in MySQL
- 0
When I was working with MySql command prompt, I was wondering how to import an available sql file into the available database. First you need to open the MySql Command prompt. And select the database. Here “smartcart” is the database. Now I select that database using “use” command as below: mysql> use smartcart; Database changed…
Read MoreDirectory Separators Ignored on Inserting into mySQL
- 0
I faced a problem while inserting the file path to mysql database. You can also encounter similar problem when you work with Mysql. So thought of adding this info for your information. While inserting a file path to my mysql table, I noticed that the slashes in the path are missed once they added to…
Read MoreParagraph Retrieval from Mysql
- 0
When I was working with one of the website Designing, I noticed a strange problem. May be it’s not a problem. But for a developer it looks like a problem. Many of us can come across such issue. So I thought of penning down the known solution for it. When you store some paragraph of…
Read More