CODEWITHSUNDEEP
mysqlphpmyadmin
user2789862
user2789862

Reputation: 31

How to execute .sql files to create new tables

phpMyAdmin configuration storage (phpMyAdmin/doc/html/setup.html#linked-tables) says

[..] and then create new tables by importing examples/create_tables.sql

This is not explicit. Where do I 'import' this file? Is it an SQL script I have to execute? how? Where will these tables be created?

Upvotes: 3

Views: 8271

Answers (5)

Dhaval
Dhaval

Reputation: 901

Here are the steps how you can import the old DB:

Importing the phpmyadmin database

  • The phpmyadmin database stores details of table relations, bookmarks, history, and so on. Setting up the database simply involves importing an .sql file.

  • Launch phpMyAdmin, make sure the home screen is selected, and click the Import tab.

  • Click the Browse button in the File to Import section, and navigate to the folder where the phpmyadmin files are located. In MAMP, this is /Applications/MAMP/bin/phpmyadmin. And in XAMPP (if installed in C:) C:\xampp\phpMyAdmin\

  • Open the examples folder, and select create_tables.sql.

  • Click Go at the bottom of the Import tab to import the phpmyadmin database structure

Hope steps are helpful for you.

Upvotes: 1

Michael Fulwell
Michael Fulwell

Reputation: 11

If you've installed phpMyAdmin as an openSuSE package, the location of create_tables.sql is

/usr/share/doc/packages/phpMyAdmin/examples/create_tables.sql

You can get more help here: https://en.opensuse.org/SDB:LAMP_setup#Installing_phpMyAdmin

Upvotes: 1

Ryan
Ryan

Reputation: 14649

Open the command line;cd to the directory that contains the mysql executable; type mysql and log into the your server, then choose a database.

Now you can type source /path/to/my/sql/file.sql

Upvotes: 3

Mario.Hydrant
Mario.Hydrant

Reputation: 306

The examples/create_tables.sql file is a file that you provide. This file is an export, or data dump of a database. phpMyAdmin allows you to create and populate a new table by using the data in that file.

However, phpMyAdmin allows you to create tables from scratch.

http://php.about.com/od/learnmysql/ss/create_tables.htm

Upvotes: -1

ApplePie
ApplePie

Reputation: 8942

Following exactly what is said in your question:

  1. In my phpMyAdmin directory I can find the /examples/create_tables.sql script.

  2. Right when you open phpMyAdmin there is a tab labeled Import where you can click on a button to browse on your computer for that file. Then you can just click Go.

The script seems to only create a database called phpMyAdmin and then creates tables inside that database so that's where the tables will be located.

Upvotes: 2

Related Questions