Mysql directory path in ubuntu 20.04 tls

[av_admin]

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

[usmannasir]

Change upload size for PHPmyadmin and upload through it.

Otherwise you can use command line to restore the dump.

4 - Change Upload Limit for phpMyAdmin

To change phpMyAdmin upload limits to a higher value: Go to PHP → Edit PHP Configs → Advanced , and select php 7.3 [image] Search “post_max_size” , and change value from default 8M to size you wish , for example 100M [image] Search “upload_max_filesize” , and change value from default 2M to size you wish , for example 100M [image] Save changes [image] Restart LSCPD by following command: systemctl restart lscpd Now go to phpMyAdmin, upload size is raised with your setting. [i…

[av_admin]

Change upload size for PHPmyadmin and upload through it.

with this tutorial I did , but I got error

4 - Change Upload Limit for phpMyAdmin

From the ssh access your ssh terminal and run systemctl restart lscpd

---

Otherwise you can use command line to restore the dump.

How?

Would you please explain each of theme?

[usmannasir]

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

[av_admin]

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

[usmannasir]

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

By the way what is your OS?

[av_admin]

Ubuntu 20.04
I just want to know

[av_admin]

@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