phpmysqlphpmyadminimporterror
PhpMyAdmin Import Error-MySQL server has gone away/Unrecognized Keyword
So I've exported a MySQL database from PHPMyAdmin (which I access from within IIS Express on a Windows 8 machine) and I'm trying to import this database onto another machine, however on that machine I receive the following errors:
Please help. I need to be able to restore this database and I have no idea how to fix this.
Solution
Server has gone away often means that there is a MySQL connection timeout. This can happen if you have an especially large database dump (and it sounds like you might). You could try fiddling with your MySQL settings in mf.cnf but realistically you are far better off using the command line for a file that large:
mysql -u user -p password db_name < dumpfile.sql
- How to make a . (any character) in a PHP regex pattern also match newline characters?
- Recursive regex pattern not matching all characters as expected (PHP differs from Perl implementation)
- Drupal main theme template file for any node
- CakePHP: Automatic search on pre-selected dropdown value
- Laravel sending email call_user_func() error
- Link newly created split order to the customer from the original order in WooCommerce
- ssh2_auth_pubkey_file authentication always fails
- Finding all types of end-of-line delimiters in a file
- Convert utf8-characters to iso-88591 and back in PHP
- PHP is not reading .env file
- Laravel date->format is not working at whereDate()
- Uncaught SyntaxError: Unexpected token '<' in Laravel/Vue Application
- php .env with Docker
- New Laravel Routes not working
- Set custom shipping rates programmatically in WooCommerce 3
- How do I manually send a password reset request in Laravel 5.2?
- Process custom bulk action on admin Orders list in Woocommerce
- Reference parent column in nested relationship
- Is there a way to retrieve the data that was deleted by the statement?
- Laravel Reverb not Broadcasting REST API with Docker
- How to remove line breaks (no characters!) from the string?
- Laravel - Maintenance mode just for some urls
- Create date - Carbon in Laravel
- Adding authentication component to versionned API
- Setting up SSL on a local xampp/apache server
- php - check if class name stored in a string is implementing an interface
- How to tell Deployer to use different PHP version once ssh'ed to my shared hosting?
- Break very long words with php mpdf
- Non-null assertions can only be used in TypeScript files.javascript
- Get intersecting values per row of a 2d array where found in another flat array