database

I run a small business website and I'm wondering how frequently I should back up my website and database. Is daily backup overkill, or should I consider a weekly schedule?

In database management, triggers are an important functional component that allow developers to automatically perform predefined actions when specific events occur. Understanding the working principle of triggers and their application scenarios is of great significance for optimizing database...

Many apologies for these primitive questions. Our company hired a web developer, presumably based in the United States. We have since discovered they are actually off-shore, working through a US address. Nonetheless, they have developed our site, billed us for the cost of a Google Cloud...

Hi friends, Requirements: Easily manage MYSQL/MariaDB with creation, auto backups, clustering (HA) OS: Ubuntu 20+ Type: Cloud or Selfhosted open source. I tried Cluster CS but its not that good and mature. Usage: Production Environment in OVH Cloud. PS: i'm aware of DBAAS solutions, but iam...

I am using cpanel server, I am looking for a way to backup and restore websites including its files and databases only. Website are running on wordpress platform, I don't expect to use a plugin, i like using ways to work on hosting directly to backup files and mysql database in a fastest and...

Hello. I need help urgently and hope that I am in the right place. Sorry to bother you but I am making a list of postal codes of cities in the United States and need a dataset that can assist me to gather information for this.

I have a custom database and there is a word http:// that I want to change to https:// with a query in phpmyadmin or using CLI. What update command can I use to find and replace this text in all tables of my current database?

How can I export a Mysql database via SSH? I have too many my website databases and it consumed me more time when exporting databases from Phpmyadmin. I would like to know a way to export faster and download databases to my PC . Thanks in advance.

There will come a time in every website that uses a database life where you will see the error "Error Establish a Database Connection" Don't worry, this is more common than you think. All this means is (and I am sure you can guess by the error) that someone broke the connection from a...

I have come across lots of companies who are selling whois databases of all the active domains of most of the TLDs and ccTLDs. I was wondering from where do they get the data. I know all the registries provide zone file access to registrars. However, these companies are not even registrars...

GPDHost submitted a new resource: US Based Data Center | Unlimited MYSQL Database | Multiple PHP Version | Built-In Cloudflare - US Based Data Center | Unlimited MYSQL Database | Multiple PHP Version | Built-In Cloudflare Read more about this resource...

Hi there, I am wondering if I can host my Wordpress database (MySQL) in another server which is not the server storing the content (source code, Wodpress files, plugins, themes...etc) Will that make any performance and security improvement? Is there any service specialized in hosting only...

I want to use backup feature in cPanel but I don't know there is an option to backup that includes MySQL databases with files?

How can I change table names in phpMyAdmin? I can not see this option in phpMyAdmin. Does anyone guide me?

I have just installed CentOS Web Panel on my new VPS but after running myIP_address:2030 it alerted me this Could not select database root_cwp How can I fix this problem?

I have noticed that my MySQL server is the top reason for high load on my VPS. I want to make a database running with CPUs and instead that to run completely in memory for better performance. How do I do that? I explored PHPMyAdmin, is there a way to change there or what addons or software do I...

As title mentioned, I would like to know it is possible to backup Mysql database without using cPanel or Phpmyadmin? there are other ways to backup databases on your hosting without using those tools?

Hey guys, hope I'm posting this in the right section. I bought a script and now there's a new update which involves going to the phpMyadmin to make some changes. Now every time I try to run a query in the SQL tab, I get this error: Error SQL query: ALTER TABLE `users` ADD `ip` VARCHAR( 45 )...

Hey I write this code for delete the selected check box values from the database. Yeah I know there are some example already here. But when I take look on them and tried to do as per they done in their question. still doesn't get the success. Can you guys help me with this query. When I click on...

Do you know about WordPress Database Schema? Please give me overview about structure of wordpress database, I can control better my data with wordpress :rolleyes: Thanks