[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3266
  • Last Modified:

mysqldump database structure only

Hi

Is it possible to create a new database based on the structure of an existing database. Basically you are making a copy of an existing database without the data. I didn't know if this was something you could do with mysql or perhaps there are native sql commands for this

I am a database novice so I don't know these things.
Thanks
0
andieje
Asked:
andieje
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
If you don't want to do it via shell/command line, you can always install phpMyAdmin (www.phpmyadmin.net) and use the GUI via Apache/PHP to export the database without the data.

0
 
emphamyCommented:
you can also use sqlyog www.webyog.com, a little easier than pma
0
 
andiejeAuthor Commented:
thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now