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, 10: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, 09:19 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Posts: 9,224
Last Blog:
Ext JS or Ext GWT
Rep Power: 20
Jordan is just really niceJordan is just really niceJordan is just really niceJordan is just really nice
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
The CodeCall Wiki is now fully integrated with vBulletin users! Check it out and add some new pages!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 10-10-2007, 02:23 PM
Patrick Patrick is offline
Programmer
  
Join Date: Sep 2007
Posts: 100
Rep Power: 5
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
Forum Jump

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


All times are GMT -5. The time now is 12:46 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

WingedPanther ........ 2753.6
Xav ........ 2704
Brandon W ........ 1702.32
John ........ 1207.73
marwex89 ........ 1175.24
morefood2001 ........ 966.05
dcs ........ 655.75
Steve.L ........ 475.59
orjan ........ 418.58
Aereshaa ........ 383.54

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 98%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads