HelpThis post has been edited by gab1982: 27 April 2009 - 06:14 PM
showing sql query in phpmyadmin when importing a db
Whether you're a seasoned veteran or a struggling beginner, Web Radiance is the web development and web design forum for you. You'll find answers to all your HTML, CSS, SEO, and Programming needs. Pull up a chair and stay awhile.
Page 1 of 1
- You cannot start a new topic
-
This topic is locked
showing sql query in phpmyadmin when importing a db
Rate Topic:
#1
- W.R. Corporal
-
- Group: Members
- Posts: 55
- Joined: 24-February 07
Posted 27 April 2009 - 06:13 PM
I need to see the sql query for when i import a db from a file but all it says is 11 queries executed, i need this as i am building a setup file, if phpmyadmin can't do it does anyone have any suggestions. I thought i could do it in php but if phpmyadmin can do it or anything else can please tell me.
MultiQuote
#2
- Allegedly Legendary
-
- Group: Members
- Posts: 517
- Joined: 31-July 06
- Location:Winder, GA
Posted 27 April 2009 - 07:16 PM
What kind of file are you importing it as? If it's a sql file, then that's what you want anyways. Otherwise, phpmyadmin can export it to sql.
#3
- W.R. Corporal
-
- Group: Members
- Posts: 55
- Joined: 24-February 07
Posted 28 April 2009 - 08:36 AM
its a .sql.gz which i exported from phpmyadmin, but i need to import it so i can see what the sql query is to create the tables and their columns.
#4
- Codesmith
-
- Group: Administrators
- Posts: 1,049
- Joined: 04-April 06
- Gender:Male
- Location:San Diego
Posted 28 April 2009 - 12:38 PM
You can just open it with Notepad to see the contents.
#5
- W.R. Corporal
-
- Group: Members
- Posts: 55
- Joined: 24-February 07
Posted 28 April 2009 - 01:46 PM
thanks i got it working 
Share this topic:
Page 1 of 1
- You cannot start a new topic
-
This topic is locked