I have a backup of a database that is more than 500MB and I need to restore on a server, but every time phpMyAdmin give me error.
I want to restore it by uploading the file in my server then from terminal move it to
/mysql/data/ folder, but I don’t know the path for MySQL.
I changed PHP 7.3’s
post_max_size to 1000MB, but still have a problem when importing the database.
I have installed cyberpanel on my Ubuntu 20.04 LTS machine and want to upload the SQL dump. I received an error each time I tried to upload via the browser:
and the other one is:
Also, I have many databases in there, I found this command based on this tutorial:
mysql -u root -p[my_root_password] [mydatabase] < mydatabase.sql
This does not help me because I have serious questions:
My database is under the domain name and there are lots of db on the server, how should I find the correct name?
I have uploaded the file to my server, at the end of the command is
< mydatabase.sql. I don't know how to state which database to import the data dump to.
I'm so confused…