944,141 Members | Top Members by Rank

Web Development > PHP > Database import
Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 1017
  • PHP RSS
Permalink
Aug 2nd, 2009
0

Database import

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
anumitadas is offline Offline
17 posts
since Nov 2008
Permalink
Aug 2nd, 2009
0

Re: Database import

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.
Reputation Points: 31
Solved Threads: 27
Unverified User
Josh Connerty is offline Offline
342 posts
since Apr 2009
Permalink
Aug 2nd, 2009
0

Re: Database import

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
anumitadas is offline Offline
17 posts
since Nov 2008
Permalink
Aug 2nd, 2009
0

Re: Database import

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.
Reputation Points: 31
Solved Threads: 27
Unverified User
Josh Connerty is offline Offline
342 posts
since Apr 2009
Permalink
Aug 2nd, 2009
0

Re: Database import

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, 20 views)
Reputation Points: 10
Solved Threads: 0
Newbie Poster
anumitadas is offline Offline
17 posts
since Nov 2008
Permalink
Aug 3rd, 2009
0

Re: Database import

Hey buddy,

go to php-myadmin.then just clik import button.give the path of ur file.that's it.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ronakraval1988 is offline Offline
1 posts
since Aug 2009
Permalink
Nov 4th, 2009
0
Re: Database import
i cannot load large database file which has extension .sql on localhost of wam[
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sanjay1kumar11 is offline Offline
2 posts
since Nov 2009
Permalink
Nov 4th, 2009
0
Re: Database import
i cannot import large database file which has extension .sql. please help me quickly
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sanjay1kumar11 is offline Offline
2 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Suggestions on X-cart opensource ?
Next Thread in PHP Forum Timeline: PHP Security Framework needed...





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC