Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
How to restore a database from a large dump file Options · View
AlexP
#1 Posted : Sunday, September 8, 2013 7:28:16 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 819
Problem:
What tool should we use to restore MySQL backup? I extracted the script file and tried to run in EMS My SQL Studio but it is giving error: Could not allocate XXXXXXXXXX bytes to read file "<path-to-dump-file>".

Solution:
The solution to restore large mysql database from sql dump file is using shell command.
To restore mysql database from a dump file, just type the command below:-
mysql -u #username# -p #database# < #dump_file#
Of course you need to replace #username# to your database username and #database# to your target database. and rename #dump_file# to your dump file file name.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com