Mysql Import Export Big Databases

  • Uploaded by: Deraeck
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Mysql Import Export Big Databases as PDF for free.

More details

  • Words: 148
  • Pages: 1
How to import Big database (local or ssh) : ------------------------------------------1. Run the terminal (DOS under windows OR putty.exe for SSH connection) 2. In the mysql directory execute the following line: mysql -u user_login -p database_name < /path_to_the_file/my_backup.sql Where user_login : user login database_name : name of the database /path_to_the_file/my_backup.sql : path to the sql backup file How to export Big database (local or ssh) : ------------------------------------------1. Run the terminal (DOS under windows OR putty.exe for SSH connection) 2. In the mysql directory execute the following line: mysqldump -u user_login -p database_name > /path_to_the_file/my_backup.sql Where user_login : user login database_name : name of the database /path_to_the_file/my_backup.sql : path to the sql backup file Combell Informations : ---------------------Putty connexion (use the database authentification) Login : login without the %[domaine].[suffixe] Password : Database password For an exportation, If no path is defined the file is automaticaly saved in the server root.

Related Documents

Import Export
November 2019 17
Import Export
June 2020 21
Export Import
June 2020 15
Import And Export 2008
November 2019 23
Export And Import
October 2019 24

More Documents from "monica"