Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
I want to FTP a MySQL database table to somebody. What do I need?
Old 02-12-2009, 01:39 AM I want to FTP a MySQL database table to somebody. What do I need?
TWD
TWD's Avatar
King Spam Talker

Posts: 1,112
Trades: 0
Which files do I need to send the other party for them to copy the files to a server and then make use of the tables.

Its a non-transaction table so i guess MyISAM.
TWD is online now
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 02-12-2009, 04:42 AM Re: I want to FTP a MySQL database table to somebody. What do I need?
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
1) Make a dump of your database
2) transfer it to the other computer
3) Import the dump

For 1 and 3, 2 ways of soing it:
If you have a shell access:
Code:
mysqldump --create-options your_db_name>my_db_dump.sql
You can specify which tables you want to export too:
Code:
mysqldump --create-options your_db_name tbl1 tbl2 tbl3>my_db_dump.sql
And to restore it:
Code:
mysql -u db_user -p db_name < my_db_dump.sql
If you don't have a shell access, then use whatever tool you have access to.
Mostly, it will be phpMyAdmin, which have an export function.
http://drupal.org/node/81993

To reimport the datas, simply upload the SQL file to be executed.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 02-12-2009, 08:01 AM Re: I want to FTP a MySQL database table to somebody. What do I need?
rogem002's Avatar
PHP Chap

Posts: 843
Name: Mike
Location: United Kingdom
Trades: 0
http://uk2.php.net/manual/en/book.ftp.php < FTP function in PHP.
__________________
My Blog/Site:
Please login or register to view this content. Registration is FREE
rogem002 is offline
Reply With Quote
View Public Profile Visit rogem002's homepage!
 
Reply     « Reply to I want to FTP a MySQL database table to somebody. What do I need?
 

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 On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.12092 seconds with 12 queries