nixCraft

brothers · #1 (**permalink**) 10-23-2007, 10:47 AM

I know nothing guys I really need help with this one I googled and google and I am tired please help

I have a database with many many tables

I want only to use ssh

and backup all tables starting with phpbb_

into my public_html

Please let me know the commands I should use!

nixcraft · #2 (**permalink**) 10-23-2007, 11:08 AM

Use mysqldump to backup entire database

Code:

mysqldump -u root -p dbname > backup.db.sql

brothers · #3 (**permalink**) 10-23-2007, 11:53 AM

Thanks but I do not want to backup the entire database
I wan to only backup all tables starting with phpbb_

jesse · #4 (**permalink**) 10-25-2007, 03:26 AM

Just take a look at the help (mysqldump --help). The --tables option should do the trick.

brothers · #5 (**permalink**) 10-25-2007, 05:20 AM

Jesse I did not understand
Can you please type the exact command?
Is this possible?

jesse · #6 (**permalink**) 10-25-2007, 09:42 AM

Code:

mysqldump -u USER -p DATABASE --tables TABLE > TARGET.sql

Replace all uppercase words with your values, password will be prompted.

brothers · #7 (**permalink**) 10-25-2007, 09:52 AM

Jesse thanks but the problem is not one talble

See I have a series of tables all tables which start with

phpbb_

nixcraft · #8 (**permalink**) 10-25-2007, 11:51 AM

Try something as follows (set db name, username and password)

Code:

#!/bin/bash
DBNAME="phpbb"
DBPASS="myPassWord"
DBUSER="admin"
DBHOST="localhost"
BACKUP="out.sql"
>$BACKUP
echo ""
echo -n "*** Dumping tables to $BACKUP file : "
TABLES=$(mysql -ss -h $DBHOST -u $DBUSER -p$DBPASS $DBNANE -e'show tables like "phpbb_%";')
for t in $TABLES
do
 echo -n " $t "
 mysqldump -h $DBHOST -u $DBUSER -p $DBPASS $DBNAME --tables "$t" >> $BACKUP
done
echo " *** Done."

brothers · #9 (**permalink**) 10-25-2007, 12:31 PM

So do you mean I make a php script and run it?

sorry I have no Idea!

OK supposing this is my info

Db name: brothers
db password: 1234
dbuser: Me
Dbhost: local host

and I want to download all tables starting with phpbb2_

======================================
I want to backup my phpbb2 forum from among 500 of other tables which are not related and make a new database and restore it there

nixcraft · #10 (**permalink**) 10-25-2007, 12:39 PM

This is a shell script, it will not work from PHP until and unless you have shell access from your domain. If you have shell access it will work out.

If you don't have shell access get phpMyAdmin software upload the same and use export option select phpbb_ tables and download them to your local computer or to directory.

Download : phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
See how to backup tables with this software : WordPress Backup with phpMyAdmin

Another option is use phpbb's own backup and restore table option.

Keeping in mind that if your tables are quite big, php may not work on shared hosting account due to restrictions.

Hope this helps!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to do MYSQL online backup of huge database	manish_2479	Databases servers	4	07-12-2008 12:36 PM
need to convert text files into mysql database	zafar466	Databases servers	2	07-12-2008 12:31 PM
MySql FTP server backup script	zafar466	Shell scripting	3	09-25-2007 05:43 PM
MySQL Backup Script	krisa	Shell scripting	1	02-02-2007 11:57 PM
How do I backup MySQL Databases?	chiku	All about FreeBSD/OpenBSD/NetBSD	2	08-19-2006 07:15 PM

nixCraft

ssh backup particular mysql table / database

ssh backup particular mysql table / database

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads