The database has million of records, and will need to be backed up every data entry from the user. Answer For small databases I’m personally use phpMyAdmin. For bigger databases (SQL dump is, let’s say, more than 5MB) I prefer backing up from command line using standard MySQL tool mysqldump: mysqldump -h localhost -u username … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 8 years ago. Improve this question I need to create thousands of database such like below: CREATE DATABASE adr0711 CHARACTER SET utf8 COLLATE utf8_bin; CREATE DATABASE adr0712 CHARACTER SET … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 9 years ago. Improve this question I’m looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I’ve figured out \l, … Read more
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 8 years ago. Improve this question I recently upgraded my VPS(OpenVZ VT) to 2GB of RAM. Despite the configuration changes i make to the LAMP stack … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 2 years ago. Improve this question I need to synchronize the data in MySQL Database from another server running same application in another Location. How to do the synchronization … Read more
I have a hosted virtual server (Windows Server 2012 R2) that exists solely to host a few SQL databases. I need to purchase a SSL certificate to encrypt data but purchasing a certificate requires that the server has a fully qualified domain name. How do I create a FQD when the server doesn’t host websites … Read more
It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 9 years ago. Here’s the scenario. We create a campaign in … Read more
Recently we have been testing an HA Database solution from a 3rd party provider. I have done some stress tests to see some metrics for Master & Slave status etc, however I would like to test the actual failover. I need a way to test the failover or some other way to disable the Master … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 6 years ago. Improve this question I have been making my very first web application, and I am using PHP to develop it. I can see my VPS being … Read more
I ran the clear_iredmail script found here: http://www.iredmail.org/forum/topic333-iredmail-support-faq-how-to-uninstall-iredmail.html and accidentally deleted some important config files (and more) on my CentOS6 VPS. Fortunately CentOS keeps some file backups like my /etc/php.ini. Yet my php services installed to my website under /var/www/html were complaining certain PHP functions aren’t being defined. Furthermore, none of the services I’m using … Read more
