Mysql directory path in ubuntu 20.04 tls

an

antivirusadmin March 30, 2022, 7:38 p.m. #1

Hi
I have backup of database that is more than 500mb and I need to restor in my database but everytime 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 where is the path of mysql

Even I change the php 7.3 { upload_max_filesize and post_max_size } to 1000mb but still have probelm in importing the database

Thanks all of cyberpanel community

RM

Rana Muhammad Usman Nasir March 30, 2022, 8:55 p.m. #2

Change upload size for PHPmyadmin and upload through it.

Otherwise you can use command line to restore the dump.

an

antivirusadmin March 31, 2022, 5:12 a.m. #3

Change upload size for PHPmyadmin and upload through it.

with this tutorial I did , but I got error

Otherwise you can use command line to restore the dump.

How?

Would you please explain each of theme?

RM

Rana Muhammad Usman Nasir March 31, 2022, 6:19 a.m. #4

https://support.solarwinds.com/SuccessCenter/s/article/Back-up-and-restore-the-MySQL-database-using-the-command-line?language=en_US

an

antivirusadmin March 31, 2022, 6:43 a.m. #5

Thanks
And please tell me where is the mysql path in your cyberpanel?

RM

Rana Muhammad Usman Nasir March 31, 2022, 6:52 a.m. #6

I would recommend to avoid going into that folder, you can mess up things.

By the way what is your OS?

an

antivirusadmin March 31, 2022, 7:16 a.m. #7

Ubuntu 20.04
I just want to know

an

antivirusadmin March 31, 2022, 8:09 a.m. #8

@usmannasir
With these type of tutorial
type or paste code here

where is my sql path ? I want upload it from my pc with ssh , how should do that?

mysql -u root -p[my_root_password] [mydatabase] < mydatabase.sql

with phpmyadmin I got these errors

Closed Mysql directory path in ubuntu 20.04 tls