mysqlphpmyadmincpanel
How to import sql file of size more than 500MB to cPanel phpMyAdmin
I have .sql file of 550MB. I tried to import with phpMyAdmin in cPanel. It gives an error of max file size.
Can anyone give me idea for this.
Thanks in advance.
Solution
Make a Remote
SQLconnection with the server,it can be via:
Or via
SSHaccount.Open that connection from a client app like
MySqlWorkbenchor from terminal.Run the script file directly, rather than open it.
- How to return NULL when result is empty?
- Extract dirname from full path stored in database
- Using larger than or equal (>=) to in PreparedStatement in Java
- What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?
- Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax
- How to find the minimum of a sum of values based on a distinct value?
- How to use 'and' with 'on' condition of joins in knex
- MYSQL Update query, replace part string containing URL
- CodeIgniter SELECT query to find rows with qualifying sets of column values in a JOINed table
- can we delete wp_woocommerce_sessions from database?
- NodeJS/mySQL - ER_ACCESS_DENIED_ERROR Access denied for user 'root'@'localhost' (using password: YES)
- Fast page retrieval in MySQL, index usage?
- MySQL Not Equal To Certain Length
- Problem connecting springboot to mysql with docker-compose
- Laravel Paginate with OrderByRaw return different order
- How to update a database using a loop?
- mysql2 Segmentation fault at 0x0000000000000000
- Retrieve query results as dict in SQLAlchemy
- How to do paging of pictures in PHP
- How to make a relation between two tables without foreign key
- How to pass password from file to mysql command?
- SQL - Columns merge and grouping by column name while summation of the other column
- A hackerrank sql challenge
- MySql Leap Years
- how to prevent mysql from createing mysql-bin.00000x files?
- Data truncation: Data too long for column 'logo' at row 1
- Count number of query results in a CodeIgniter application
- Convert raw MySQL containing a JOIN on identical column names and a WHERE and ORDER BY clause to CodeIgniter active record
- How to create MySQL function to update database if a value reaches 800?
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]