Advice Articles

  • Beginners
    Just getting started? Loads of powerful advice here for beginners.
  • Intermediate
    Got a handle on the basics? Find more advanced topics covered here.
  • Advanced
    Warning! Advanced topics covered here.
  • Affiliate resources
    Affiliate marketing resources for affiliates and affiliate program managers tools, websites, books and articles.
  • Product reviews
    Candid reviews of the latest products to take you to the next level.


  

Advanced Search

Affiliate Marketing Forum

FAQFAQ  SearchSearch  MemberlistMemberlist  UsergroupsUsergroups   RegisterRegister ProfileProfile  Log in to check your private messagesPrivate Messages Log inLog in  
Help with MySQL database file

 Affiliate Marketing Forum Index -> Do-It-Your-Selfers
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
raad2005



Joined: 04 Dec 2005
Posts: 15
Location: Malaysia
PostPosted: Thu Feb 02, 2006 1:57 pm    Post subject: Help with MySQL database file Reply with quote
I did a backup for the MySQL databse file of my web site as a zip file. When I try to open the saved file I get the message ?Please enter the full name of the file contained within the archive?? MySQLbackup.gz. For example, if the contents is a DOC file, a recommended filename is phpbb1.doc?. Now what shall I use as file extension in order to read the MySQL database file? Please help..

Regards
_________________
Raad
http://www.cmalaysia.net
Back to top View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
jonny361



Joined: 08 Jan 2006
Posts: 17
PostPosted: Thu Feb 02, 2006 4:07 pm    Post subject: Reply with quote
Hi

Try saving the file as MySQLbackup.sql
_________________
http://Loans365.net/
http://FontStore.net/
Back to top View user's profile Send private message
raad2005



Joined: 04 Dec 2005
Posts: 15
Location: Malaysia
PostPosted: Fri Feb 03, 2006 3:03 am    Post subject: .sql file Reply with quote
Thnk you,
I download the database file of my website and save it as .sql file. Can someone tell me how to read the .sql file on my PC? I need to view the data in the .sql file.

Thanks
_________________
Raad
http://www.cmalaysia.net
Back to top View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
jonny361



Joined: 08 Jan 2006
Posts: 17
PostPosted: Fri Feb 03, 2006 9:18 am    Post subject: Reply with quote
Hi

Try this application

http://www.mysqlfront.de/
_________________
http://Loans365.net/
http://FontStore.net/
Back to top View user's profile Send private message
varunpratap



Joined: 17 Aug 2004
Posts: 534
PostPosted: Fri Feb 03, 2006 9:52 am    Post subject: Reply with quote
Quote:
MySQLbackup.gz

If I remember right then .gz is Gzip format used in ZIpping files in Linux...
if it's the case then you might need to winzip or some other archive file software which you can found it at www.download.com
Varun Pratap
_________________
My Blog with Step by Step 30 Internet Success Challenge

Internet Marketing Tips
Back to top View user's profile Send private message
jhunt



Joined: 10 Jun 2006
Posts: 14
Location: Portland, Oregon
PostPosted: Tue Jun 13, 2006 1:45 am    Post subject: Reply with quote
GnuZip is a compression format that isn't platform specific, in that you can open gzipped documents with a number of applications on a variety of different operating systems and OS versions. PKZIP, StuffIt (on the mac), and a variety of other applications can extract data from gzip archives. I also recommend going to Download.com for more information.

If you want to read the data contained in a .SQL file, it's really simple, actually. You can open the file in Notepad, Word, BBEdit, Dreamweaver, or any other application that can read and write text files. Because, that's all a SQL file is: text.

Hope this helps.
Jeff
_________________
Jeffrey Hunt, Web technologist at large
Web application development and consulting services
Brief resume: http://www.pdxi.net/docs/resume.php
Toll Free: 866.865.0710 :: Email: info@removethis.pdxi.net
Back to top View user's profile Send private message Visit poster's website
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Affiliate Marketing Forum Index -> Do-It-Your-Selfers All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum





Your host: Allan Gardyne.
Earning a good living from affiliate programs since 1998.