LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-16-2017, 01:54 AM   #1
taru.tarak
Member
 
Registered: Aug 2016
Distribution: CentOS
Posts: 81

Rep: Reputation: Disabled
Export a MySQL database including all stored procedures


Hello,

How do I export a MySQL database including all stored procedures via phpMyAdmin? I have no command line access and I am using the phpMyAdmin version 4.0.10.18.

Thanks,
 
Old 05-16-2017, 02:07 AM   #2
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1009Reputation: 1009Reputation: 1009Reputation: 1009Reputation: 1009Reputation: 1009Reputation: 1009Reputation: 1009
Is there some reason why you're asking here instead of phpmyadmin.net?
 
Old 05-16-2017, 02:16 AM   #3
taru.tarak
Member
 
Registered: Aug 2016
Distribution: CentOS
Posts: 81

Original Poster
Rep: Reputation: Disabled
Sorry for that... I thought someone will help.
 
Old 05-16-2017, 02:42 AM   #4
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=14, FreeBSD_12{.0|.1}
Posts: 5,622
Blog Entries: 11

Rep: Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657Reputation: 3657
I do not often use PHPMyAdmin, but have access to a few remote sites where it is available. I just logged into one to look at what it offers.

This one is version 4.3.8, but I have not seen many big changes in it since they broke the old good interface years ago.

Choose Export from the top option tabs, then choose Custom for Export Method. The simply check the desired little boxesuntil you get to the bottom. Along the way you will see options to include stored procedures, triggers and just about any other MySQL table and data option you can think of. Here is a text copy of the form options under Object creation options:

Code:
Object creation options

    Add statements:
        Add DROP TABLE / TRIGGER statement
        Add CREATE TABLE statement
        Add CREATE VIEW statement
        Add CREATE PROCEDURE / FUNCTION / EVENT statement
        Add CREATE TRIGGER statement
        CREATE TABLE options:
            IF NOT EXISTS
            AUTO_INCREMENT
 
Old 05-16-2017, 06:58 AM   #5
r3sistance
Senior Member
 
Registered: Mar 2004
Location: UK
Distribution: CentOS 6/7
Posts: 1,375

Rep: Reputation: 217Reputation: 217Reputation: 217
personally dislike phpmyadmin, since it is often insecure unless set-up meticulously.

Anyways doing it with mysqldump on the CLI is generally easily enough, if you are using innodb/xtradb (which I highly recommend), then you can dump everything to a .sql file with the system online and avoid locking. Something along the lines of:

mysqldump -A --events --routines --singletransaction >> /some/sql.file
 
Old 05-16-2017, 08:47 AM   #6
taru.tarak
Member
 
Registered: Aug 2016
Distribution: CentOS
Posts: 81

Original Poster
Rep: Reputation: Disabled
Thank you very much everyone.
 
Old 05-16-2017, 04:18 PM   #7
Doug G
Member
 
Registered: Jul 2013
Posts: 749

Rep: Reputation: Disabled
Haven't tried, but here's an answer that looks reasonable: http://stackoverflow.com/questions/2...rom-phpmyadmin
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
NET Code generators for C# and SQL Stored Procedures willow_jones Programming 1 12-12-2007 02:58 AM
LXer: Use XML in DB2 SQL stored procedures LXer Syndicated Linux News 0 01-20-2007 04:03 AM
Php/MS-SQL/Stored Procedures joelhop Programming 2 10-12-2006 02:01 PM
LXer: DB2 Eclipse-Based Workbench and Stored Procedures LXer Syndicated Linux News 0 09-15-2006 10:21 PM
SQL Stored Procedures paddyjoy Programming 1 09-29-2005 11:42 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:40 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration