mysqlTag Archive

When users update their profile information, it is important to ensure that certain fields, such as mobile numbers, remain unique across all user accounts. This article explains how to prevent users from updating their profile with a mobile number that is already assigned to another account. Scenario Assume you have… Continue Reading how to avoid inserting duplicate row in php while update user profile

Introduction Regular database backups are essential for protecting your data and ensuring quick recovery in the event of data loss. If you maintain an FTP server for offsite backups, you can automate the process of backing up all MySQL databases and uploading them daily. This guide demonstrates a simple shell… Continue Reading FTP Backup Script for All MySQL Databases

Introduction MySQL databases are used by many web applications to store and manage data. In cPanel, you can easily create a database, create a database user, and assign the user to the database with the required privileges. Prerequisites Implementation Step 1 Log in to your cPanel account. Step 2 Navigate… Continue Reading Create a database and the user for that database in cPanel