LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 09-16-2011, 11:26 AM   #1
jindalarpan
Member
 
Registered: Mar 2006
Posts: 94

Rep: Reputation: 15
mysql schema list and taking backup using php


Hello All

I am new to php so i am posting over here,
I need a help in doing to following.
I want to take the backup of mysql schema using web access, for setting up the same i need to firt put the list of schema and then from there once user selects the schema schema backup shuold start up and return the path on the server where the backup is kept.

i cant do this using phpmyadmin as it has limit on size of dump file.


kindly provide inputs

thanks
 
Old 09-17-2011, 01:55 PM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,827

Rep: Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636Reputation: 2636
Quote:
Originally Posted by jindalarpan View Post
Hello All
I am new to php so i am posting over here, I need a help in doing to following. I want to take the backup of mysql schema using web access, for setting up the same i need to firt put the list of schema and then from there once user selects the schema schema backup shuold start up and return the path on the server where the backup is kept.

i cant do this using phpmyadmin as it has limit on size of dump file.
Write a script that uses the built-in mysqldump program. The man page on mysqldump has details on all the options..you can do just one table, a whole DB, or a whole server. You can even use triggers, and table-locking, too, depending on how you call the program.

So, first step is to write the script to act how you'd like, and easily test it on the command-line. From there, use a PHP system call (system, exec, etc.), to call the shell script, and pass it whatever variables you'd like.
 
  


Reply

Tags
mysql, mysqldump, php


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
Taking backup in dvd under linux peddip Linux - General 5 05-07-2009 08:20 AM
Auto generation of MySQL schema diagrams? koyi Linux - Software 3 07-24-2008 05:45 AM
LXer: Learn to Export Database Schema as XML in PHP LXer Syndicated Linux News 0 02-12-2007 01:54 PM
Error while taking OS backup mady988 AIX 1 12-16-2006 01:42 PM
LXer: Taking Advantage Of Open Source PHP MySQL Applications LXer Syndicated Linux News 0 12-28-2005 08:16 PM


All times are GMT -5. The time now is 12:22 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration