RE: Increase MYsql file size Upload
10-03-2017, 06:37 AM
(This post was last modified: 10-03-2017, 06:39 AM by testing.)
I followed these methods to import my db to mysql keep getting error for no such file or directory.
mysql -u username -p database_name < file.sql ( like you mentioned above) it didnt work. My first is present inside ( /public_html/mydomain_com/db.sql)
mysql -u dbusername -pdbpassword dbname < /public_html/domain_com/db.sql ( but same error - no such file or directory. ) so what is the path to my .sql if it's not present inside according to ssh.
I have made change in this but I still want to learn ssh way also cause it's all about getting knowing more to understand better. I will upload via phpmyadmin but first i want to try it via ssh. Most likely I will break some db or something, i will reinstall os and will begin at zero, but its' going to get me learn better.
mysql -u username -p database_name < file.sql ( like you mentioned above) it didnt work. My first is present inside ( /public_html/mydomain_com/db.sql)
mysql -u dbusername -pdbpassword dbname < /public_html/domain_com/db.sql ( but same error - no such file or directory. ) so what is the path to my .sql if it's not present inside according to ssh.
(10-02-2017, 08:14 PM)betatester3.0 Wrote: I completely forgot that phpmyadmin needs to changes,
re open the php.ini file and find "post_max_size = " and put the size you would like.
so the two that has to be changed to work with phpmyadmin is:
max_file_upload = 5G
post_max_size = 5G
hit ctrl+x then Y to save. That should work aas I just tested it, although It might not display the 5gb max size it might show the previous 2,088kb.
That should work, if it does not then fiddle around with the values of the following:
post_max_size =
upload_max_filesize =
max_execution_time =
max_input_time =
memory_limit = 256MB
You could do it via ssh, but if you are not familiar with the methods it would be much better for you to use phpmyadmin as it would not cause any problems if you do mess up. although if you mess up using ssh as root user you could do some damage to a important db or file.
I have made change in this but I still want to learn ssh way also cause it's all about getting knowing more to understand better. I will upload via phpmyadmin but first i want to try it via ssh. Most likely I will break some db or something, i will reinstall os and will begin at zero, but its' going to get me learn better.