The Everywhere Cloud

Deploy an instance.
Accelerate your application.

Uploading Old Data to a New MariaDB Database

The following command-line procedure makes a database in MariaDB (previously MySQL) and populates it with content from a backup file.


user@host: $ mariadb -u root -p -h localhost


MariaDB > USE dbname;

MariaDB > SELECT database();
-- Checks if the intended database is the one being used.

MariaDB > SOURCE dirname/filename;
-- Location of the backup file.

MariaDB > SHOW tables;
-- Verifies if the tables uploaded are from the backup file.

MariaDB > GRANT ALL ON dbname.* TO 'username'@'localhost' IDENTIFIED BY 'password';

MariaDB > QUIT;



Getting paid internationally?
Choose Payoneer.

Get started with DigitalOcean SSD Virtual Servers  Email Newsletters & Email Marketing by

Popular posts from this blog

Enabling HTTPS in Home Assistant

Running Home Assistant on FreeBSD Servers

Configuring the FreeBSD Firewall with IPFW