Dedicated SEO Servers Solution
1, Check your MySQL is running or not. From the command-line you can follow the below pasted command: /etc/init.d/mysql status If it’s running the output should be like; [[email protected] ~]# /etc/init.d/mysql status mysqld (pid 837) is running… Okay, then we can move onto database and the user “roundcube”. The database and the user is “roundcube”. […]
Continue ReadingIf you have control of the server and you are running legacy code you can’t easily change, you can adjust the SQL mode of the server and remove “only_full_group_by” either for the duration of boot, by running the query SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));’ or by adding sql_mode=” to your my.cnf file. Obviously its better to change your code if […]
Continue ReadingWhy does MySQL consume high memory? Application software like Python, PHP, JAVA threads utilize more memory when configured improperly or un-optimized queries, complex coding, etc. Due to improper configuration of MySQL, it leads to inefficient memory or wastage of memory. If the memory is lower than, required by the processes on the server. Resolutions to […]
Continue ReadingMake sure you have your database created and a user attached to it. Please remember to copy or write down the information as you will need it in step 5. Upload your SQL file to the server by either using the File Manager or a FTP Client. It does not matter where you upload it, just remember its location as you will […]
Continue ReadingPlease refer the following steps: a) Login to your MySQL server using Secure Shell (SSH). b) Enter the following command at root prompt: mysqlcheck -r [database name] Where, mysqlcheck is the command to check the database, -r is the command to repair the corrupted tables. Replace the [database name] with your actual database name. Please note that MyISAM is a default storage engine […]
Continue ReadingGet following error on php site and upload images, video, files, not working also folder creation & copy files from other server via url copy not working. error display as bellow ================================================================================ Fatal error: [SQL] [1364] Field ‘icon’ doesn’t have a default value INSERT INTO files (`name`,`path`,`pid`,`time`,`size`) VALUES ================================================================================ here is solution: looks to be […]
Continue ReadingYou’re not able to empty the eximstats database via the MySQL command line while the MySQL service is down. I moved away the eximstats database by running the following command: mv -v /var/lib/mysql/eximstats /home/cptechs/ Your server’s / partition has free space now: ===== [email protected] ~]cPs# df -h / Filesystem Size Used Avail Use% Mounted on […]
Continue ReadingHow to backup/restore your MySQL database cPanel Plesk 10 If you run a database driven website, it is important to backup your databases, periodically. You can generate a full backup to do this, but you may decide it is unnecessary to backup everything. So, here is how to backup just your databases. To backup the databases please […]
Continue ReadingSQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to […]
Continue ReadingDatabase YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps. Step 1: Retrive the Logical file name of the database from backup. RESTORE FILELISTONLY FROM DISK = ‘D:BackUpYourBaackUpFile.bak’ GO Step 2: Use the values in the LogicalName Column in following Step. —-Make Database to single user Mode ALTER DATABASE YourDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE —-Restore Database RESTORE DATABASE YourDB FROM […]
Continue Reading