Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Restoring a .SQL File
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-25-2007, 09:17 AM
gisore gisore is offline
Newbie
  
Join Date: Jul 2006
Posts: 1
Rep Power: 0
gisore is on a distinguished road
Default Restoring a .SQL File
My host sent me a .SQL file after I was hacked and lost all of my data. I know what to do with the tar.gz file but have no idea how to restore this file. I understand it is a mysql dump file. Can someone please tell me how to get this loaded back into MySQL?

Gisore
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 09-26-2007, 08:19 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 26
Posts: 5,963
Last Blog:
SAP, ERP and EDI
Rep Power: 20
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
To restore a database from a SQL file use this command:

MySQL Code:
  1. mysql -u <username> -p <databasename> < file.sql
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 10-10-2007, 01:23 PM
Patrick Patrick is offline
Programmer
  
Join Date: Sep 2007
Posts: 100
Rep Power: 4
Patrick is on a distinguished road
Default
I agree with Mr. Jordan but for this you also need a software like putty which will help you to upload all your .SQL file to your mysql server.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Project: ionFiles - Joomla Simple File Download Jordan Community Projects 302 08-30-2008 04:49 PM
File Manager Jaan Community Projects 45 08-27-2008 11:11 AM
Windows XP Tricks & Tips!!!!..new ones. pranky Tutorials 9 08-23-2008 03:22 PM
text file manipulations in vb6.0 Ronin_paes Visual Basic Programming 3 06-11-2007 04:54 AM
File I/O (newbie question) ntmurphy C and C++ 4 04-04-2007 02:30 AM


All times are GMT -5. The time now is 11:25 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

John ........ 223.00000
dargueta ........ 168.00000
Xav ........ 164.00000
LogicKills ........ 20.00000
sam ........ 20.00000
gaylo565 ........ 18.00000
|pH| ........ 15.00000
WingedPanther ........ 15.00000
Johnnyboy ........ 3.00000
navghost ........ 1.00000

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 67%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads