![]() = Local system information = version = /usr/local/bin/mysqldump-secure (0.16.3) vdate = config = /etc/nf uname = Linux 4.4.0-79-generic hostname = user = devilbox group = devilbox mysqldump = /usr/bin/mysqldump (10.14 Distrib 5.5.52-MariaDB) mysql = /usr/bin/mysql (15.1 Distrib 5.5.52-MariaDB) compressor = /usr/bin/gzip (gzip 1.5) encryptor = Not used = Database / File information = db_name = mysql db_size = 687326 Bytes (0.66 MB) tbl_cnt = 30 file_path = /shared/backups/mysql file_name = _13-31_ file_size = 136751 Bytes (0.13 MB) file_chmod = 0644 file_owner = devilbox file_group = devilbox file_mtime = 1497699116 ( 13:31:56 CEST ) file_md5 = 8d1a6c38f81c691bc4b490e7024a4f72 file_sha = 11fb85282ea866dfc69d29dc02a0418bebfea30e7e566c3c588a50987aceac2f = Dump procedure information = encrypted = 0 compressed = 1 arguments = -opt -default-character-set=utf8 -events -triggers -routines -hex-blob -complete-insert -extended-insert -compress -lock-tables -skip-quick duration = 1 sec compressor = gzip arguments = -9 -stdout encryptor = algorithm = pubkey = Server information = protocol = mysql via TCP/IP secured = No SSL arguments = -defaults-file=/etc/mysqldump-secure.cnf hostname = 001b3750b549 port = 3306 replica = master version = MariaDB 10.1. Use the single-transaction option to set the transaction isolation mode to REPEATABLE READ and send a START TRANSACTION SQL statement to the server before dumping data. Before you begin migrating your database, do the following. Login to your cPanel account and click on the phpMyAdmin icon under the Databases. Dump and restore using phpMyAdmin Prerequisites. Please either split the database before importing or import via SSH please refer to. If you are having troubles importing big files, please consult 1.16 I cannot upload big dump files (memory, HTTP or timeout problems). How to Import and Export the MySQL Database with phpMyAdmin1. Note: The maximum size for a sql upload via phpMyAdmin is 50MB. This is the header of the file and the first sql statement that cuses the error: Galaxydreams at 20:59 Looks like you will have to edit the file manually and fix the syntax. The file is created years ago using PHPMyAdmin by somebody who I don't know them. mysqldump-secure backup record Do not alter this file! Creation of this file can be turned off via config file. In addition to the standard Import and Export tab, you can also import an SQL file directly by dragging and dropping it from your local file manager to the phpMyAdmin interface in your web browser. In my project, I need to import the file into MySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |