Member Avatar for chennaipackers

how to import the sql file in an exist database connection..

Regards

Edited by pritaeas because: Removed fake signature. Read our member rules!
  • 3 Contributors
  • 2 Replies
  • 205 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by IIM
Member Avatar for NardCake

I'm not quite sure what you mean... Do you want to fetch an SQL file and run the query that it contains? Just fetch the contents of the file end put the contents in the mysqli_query().

Member Avatar for IIM

this is just simple query.Do you want to do using PHP or by mysql.
For mysql just run this command(before this add path of mysql till bin in your system variable path)

mysql -u <user> -p<password> -h <hostname> <database> < /path/to/updated_script/database.sql

or another way is

mysql> Create database test
mysql> use test
Then import the database into test databse by using one of this commend:-
source test.sql
or
./ test.sql
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.