Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

fantasyware

What does it mean to dump?

6 posts in this topic

Hi,

 

I am installing a contibution called menu tabs v2

 

It wants me to "dump" various SQL commands? What does it mean to dump? I have mysql admin and use it to use SQL commands, but am not sure how I should "dump" the SQL that the author gives.

 

thanks for your help,

-Alex

Share this post


Link to post
Share on other sites

How would export help? I see that export means to saveing your database as another file, but what does that have to do with dump?

Share this post


Link to post
Share on other sites

Sorry, I have not looked at the contribution in question. Typically, when one refers to "dumping" a database, they mean to export the contents to a file that can be later imported. It could be that the contribution author meant something entirely different.

 

If you have a series of SQL commands that are to be executed, to insert rows or create tables, then you want the "SQL" tab in phpmyadmin.

Share this post


Link to post
Share on other sites

Hi, thanks a lot for your help. I do know how to use the SQL command as you said, but I'm a bit confused still about why the author would want me to "dump" the database.

 

The reason I'm so concerned is because I tried not dumping the database and just inserting the commands into SQL and the contribution did not seem to work properly.

 

Here are the instructions pertaining to dumping:

 

---------------

 

Dumping data for table `tab_conf_active`

#

 

INSERT INTO tab_conf_active (tab_conf_active_id, tab_conf_active_name, tab_conf_active_on) VALUES (1, 'Default', 1);

INSERT INTO tab_conf_active (tab_conf_active_id, tab_conf_active_name, tab_conf_active_on) VALUES (3, 'Right', 0);

INSERT INTO tab_conf_active (tab_conf_active_id, tab_conf_active_name, tab_conf_active_on) VALUES (2, 'Left', 0);

# --------------------------------------------------------

 

Can you make any sense of it?

 

Thanks again,

-Alex

Share this post


Link to post
Share on other sites

Ok. The "dumping" is not part of the instructions - rather, it's output from the export command the author used. Just execute the INSERT commands.

Share this post


Link to post
Share on other sites