Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question

Question

Error in importing mysql file using command line

Connected Tutorial
This question is a follow-up to this tutorial:
How To Import and Export Databases in MySQL or MariaDB

Thank you for these useful commands I try to import a large SQL file but I have this error

<b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in <b>C:inNMPWW

I tried to increase max_execution_time in php.ini but the error did not fixed.

Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

anas alpure • September 24, 2021
Accepted Answer

mysql -u root -p xxxx_db < xxx_db_file.sql

Start Using Managed DatabasesProduct

Want a more reliable, scalable database?

  • Let us manage the database engine for your app so you can focus on building
  • Choose from 3 database engines: PostgreSQL, Redis, and MySQL
  • We'll handle setting up, backing up, updating, and restoring for you

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question
Start Using Managed DatabasesProduct

Want a more reliable, scalable database?

  • Let us manage the database engine for your app so you can focus on building
  • Choose from 3 database engines: PostgreSQL, Redis, and MySQL
  • We'll handle setting up, backing up, updating, and restoring for you