MYD MYI export MySQL phpmyadmin

[otchiwamodxx]

There is a 6 GB SQL including MYD and MYI, how can I transfer it to the database? , accepts infinity free SQL extension , can someone help ?

[Oxy]

Hi and welcome to the forum

You do not have permission to access /var/lib/mysql/ (you are not a server admin)
so you can’t upload myd, myi, etc. there

But you can convert the files to a .sql

Uploading large backups

How to import a MySQL database backup

If you’re moving your website from an existing hosting provider, or it simply doesn’t have an installation wizard, you may wish to import a MySQL dump file. To use a database backup, you first need to create a new database and configure your script to use it. Then, to import the database: Login to the control panel. Go to phpMyAdmin. Find the new database in the list and click Connect Now. Click Import in the top bar. Select the database backup file to import and click Go. Uploading large ba…

[Admin]

MYD and MYI files are raw MySQL table files. On their own, you can’t do much with them. phpMyAdmin definitely can’t do anything with them. As part of the entire MySQL data directory, you can restore an entire server. But no hosting provider, or any other provider that manages the MySQL server for you, will let you touch the MySQL data directory.

Also, 6 GB is a pretty big database. We don’t have a hard cap on the size of a database here, but I think you’ll run into trouble with a database that big.