Database import

Reply

Join Date: Nov 2008
Posts: 13
Reputation: anumitadas is an unknown quantity at this point 
Solved Threads: 0
anumitadas anumitadas is offline Offline
Newbie Poster

Database import

 
0
  #1
Aug 2nd, 2009
How to import file in wamp server?

I have a database file named as db.opt .I want to save this file in proper location so that I can access database from wamp server..Its showing unable to access database everytime.
I saved those file in wamp\bin\mysql\mysql5.1.36\data.
But I cant access database when trying to run the pages.
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 340
Reputation: Josh Connerty is an unknown quantity at this point 
Solved Threads: 26
Josh Connerty's Avatar
Josh Connerty Josh Connerty is offline Offline
Posting Whiz

Re: Database import

 
0
  #2
Aug 2nd, 2009
You need to import the database first, in order to do this you must use the PHPmyadmin import system or the SQL system, personally I prefer the import system.

In order to do this you must open the file and copy all of the contents into the SQL input box of PHPmyadmin. This will import all of the settings for your database.
Posts should be like mini-skirts, long enough to cover enough, but not too long that you cover too much.

My Liveperson: http://liveperson.com/josh-connerty/
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 13
Reputation: anumitadas is an unknown quantity at this point 
Solved Threads: 0
anumitadas anumitadas is offline Offline
Newbie Poster

Re: Database import

 
0
  #3
Aug 2nd, 2009
Thank you


I tried..but showing this error


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default-character-set=latin1 default-collation=latin1_swedish_ci' at line 1
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 340
Reputation: Josh Connerty is an unknown quantity at this point 
Solved Threads: 26
Josh Connerty's Avatar
Josh Connerty Josh Connerty is offline Offline
Posting Whiz

Re: Database import

 
0
  #4
Aug 2nd, 2009
Can you copy and paste the contents of the file into a code wrapper as follows:
[code=sql]
Last edited by Josh Connerty; Aug 2nd, 2009 at 10:52 am.
Posts should be like mini-skirts, long enough to cover enough, but not too long that you cover too much.

My Liveperson: http://liveperson.com/josh-connerty/
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 13
Reputation: anumitadas is an unknown quantity at this point 
Solved Threads: 0
anumitadas anumitadas is offline Offline
Newbie Poster

Re: Database import

 
0
  #5
Aug 2nd, 2009
I have uploaded my database file..
As I had made that in wamp server so the extensions are .opt and .frm

I cd nt copy the code.
Avtualy after done this database my window corupted.so I had to format my computer..now when I am trying to reuse..problem occur
Attached Files
File Type: zip database.zip (590 Bytes, 1 views)
Reply With Quote Quick reply to this message  
Join Date: Aug 2009
Posts: 1
Reputation: ronakraval1988 is an unknown quantity at this point 
Solved Threads: 0
ronakraval1988 ronakraval1988 is offline Offline
Newbie Poster

Re: Database import

 
0
  #6
Aug 3rd, 2009
Hey buddy,

go to php-myadmin.then just clik import button.give the path of ur file.that's it.
Reply With Quote Quick reply to this message  
Join Date: Nov 2009
Posts: 2
Reputation: sanjay1kumar11 is an unknown quantity at this point 
Solved Threads: 0
sanjay1kumar11 sanjay1kumar11 is offline Offline
Newbie Poster
 
0
  #7
Nov 4th, 2009
i cannot load large database file which has extension .sql on localhost of wam[
Reply With Quote Quick reply to this message  
Join Date: Nov 2009
Posts: 2
Reputation: sanjay1kumar11 is an unknown quantity at this point 
Solved Threads: 0
sanjay1kumar11 sanjay1kumar11 is offline Offline
Newbie Poster
 
0
  #8
Nov 4th, 2009
i cannot import large database file which has extension .sql. please help me quickly
Reply With Quote Quick reply to this message  
Reply

Message:




Views: 391 | Replies: 7
Thread Tools Search this Thread



Tag cloud for PHP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC