Importing sql tables with heidisql
-
- New to forums
- Posts: 1
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sat May 14, 2011 9:50 am
Importing sql tables with heidisql
I'm launching a garry's mod server shortly, and the gamemode calls for a mysql database. We've created our database in the panel and I am now attempting to import our tables, but HeidiSQL won't let me do this. Does anyone know how to import tables in Heidi, or recommend any programs that can?
Re: Importing sql tables with heidisql
I'm not familiar with HeidiSQL, but you should be able to import an .sql file through the command line, as well, with a command like:
mysql -p < yourfile.sql
It will ask you for your password when you do this.
Alternately, phpMyAdmin is a standard GUI solution for managing MySQL databases.
mysql -p < yourfile.sql
It will ask you for your password when you do this.
Alternately, phpMyAdmin is a standard GUI solution for managing MySQL databases.