Mysql Help

[K Y R I X]

I have a mysql backup of multicraft before i reinstall my vps i want to import it but it won't anyone can he me

 

[AlexTheGreat]

The multicraft daemon file cannot be uploaded through phpmyadmin because it is too big. You need to import it by command line, best of luck

 

[sergivb01]

You must use:

mysql -u username -p database_name < file.sql

You will need to enter the password (not visible).

Source: https://stackoverflow.com/questions...t-an-sql-file-using-the-command-line-in-mysql

 

[ProperPvP]

You don't have to necessarily use MySQL cli tool, although it would be a lot faster.

If you have root access you can increase PHP's max upload file size in the php.ini file to 16MB and you'll be able to import the SQL dumps. Or you can just open the SQL file and split some of the queries into a few files and just import on by one. But using the MySQL CLI tool would be a lot faster and more practical

 

[arrayofc]

If the size is too big and your phpMyAdmin times out while trying to import the files I would strongly recommend using BigDump, it's very efficient and has helped me out alot before. No need to import through command line.

Spoiler: Video Tutorial