Uploading large files to Mariadb from cmd
neo
I'm using XAAMP and the information about database is as follows
I was trying to upload employees sample database from https://launchpad.net/test-db/ through CMD but I don't have much knowledge about mariaDB commands and all the information's on google is for mysql.
My command line for C:\xampp\mysql\bin\mysql.exe opens as below not as normal mysql.
Notice the MariaDB[<none>]>
I have set a custom password for the database in phpmyadmin for root.
What is the command line to upload the large mysql database from the folder C:\xampp\mysql\employees_db
Hackerman
Actually that is very easy:
First, you need to unzip the database in
C:\xampp\mysql\bin\folderThen, you have all the
*.sqlfiles in that folder, right?Now, open a command line and type the following commands:
cd C:\xampp\mysql\bin\
mysql.exe -u root -p yourDatabasePassword < employees.sql
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
Uploading Large HD Video Files to Amazon Web Services S3
- 2
Dropzone.js : Screen hangs when uploading large number of files
- 3
Can't run .class files from CMD
- 4
Performance issues uploading large text files via Paperclip
- 5
Amazon S3 Low Level API uploading Large files
- 6
Trouble Uploading Large Files to RStudio using Louis Aslett's AMI on EC2
- 7
Uploading large files to proftpd through paramiko times out
- 8
Uploading files to s3 using s3cmd in parallel
- 9
Uploading large Files with HttpWebRequest (AllowWriteSteamBuffering doesnt solve this)
- 10
XMLHttpRequest ::ERR_CONNECTION_RESET while uploading large (2 Mo & More) files
- 11
Uploading file array from android to $_FILES
- 12
Uploading files to REST from java side works, from python not
- 13
Uploading multiple files with multer, but from different fields?
- 14
Uploading large files via Zuul
- 15
Uploading large files to Google Storage GCE from a Kubernetes pod
- 16
Download a files from a website using cmd prompt
- 17
Solutions for uploading a large file to Amazon Web Services from local machine
- 18
No response when uploading relatively large files to server
- 19
Uploading large Files with HttpWebRequest (AllowWriteSteamBuffering doesnt solve this)
- 20
Uploading/Deleting files from a database in Django
- 21
How to extract files from tree using CMD
- 22
Deleting Files from CMD or Powershell and Recycle Bin
- 23
Fetching data from large files
- 24
Uploading large folders to Onedrive
- 25
MemoryError when uploading large files to Tornado HTTP server
- 26
Copy files from SFTP with CMD
- 27
Ubuntu server crashes while uploading large files
- 28
large size Images not uploading
- 29
Django API not uploading large json data from Android OkkHttp Client
Comments