Previous Thread
Next Thread
Print Thread
Rate Thread
quick way of exporting tables? #283759
02/22/2005 3:43 PM
02/22/2005 3:43 PM
Joined: Jun 2001
Posts: 363
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 363
uk
OK, as you know, with ubbthreads, if you wish to export from another program, eg, vbulletin, and import and convert to ubbthreads, you have to manually export each table seperatly as explained here:

http://www.ubbcentral.com/support/docs/ubbthreads/UBBTadmin.html#_Toc80168406


Now then, is there a quick way of doing this?

Sponsored Links
Re: quick way of exporting tables? [Re: Luka_dup1] #283760
02/22/2005 3:50 PM
02/22/2005 3:50 PM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
You can use phpMyAdmin if you want to use a GUI to export the database or mysqldum p (commmand line tool).

http://www.phpmyadmin.org
http://dev.mysql.com/doc/mysql/en/mysqldump.html

Re: quick way of exporting tables? [Re: -Fusion-] #283761
02/22/2005 4:15 PM
02/22/2005 4:15 PM
Joined: Jun 2001
Posts: 363
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 363
uk
I didnt think that ubb supports full database imports?
Only table csv files....

Thats my problem, exporting each table one by one is very time consuming, even in phpmyadmin.

Re: quick way of exporting tables? [Re: Luka_dup1] #283762
02/23/2005 3:53 AM
02/23/2005 3:53 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
Both, phpMyAdmin and mysqldump can export to CSV.

If you use mysqldump like this:
mysqldump u <user> p t -T <output directory> --fields-enclosed-by='"' --fields-terminated-by=',' <db_name>

It automatically genereates a seperate file for each table in the database.

Re: quick way of exporting tables? [Re: -Fusion-] #283763
02/23/2005 4:11 AM
02/23/2005 4:11 AM
Joined: Jun 2001
Posts: 363
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 363
uk
hmmm, i'm not too confident using mysqldump command line.

How would you export a whole database into seperate tables in one go using phpmyadmin?
I can only find the option to export it table by table...

Sponsored Links
Re: quick way of exporting tables? [Re: Luka_dup1] #283764
02/23/2005 4:26 AM
02/23/2005 4:26 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
You can't with phpMyAdmin, you have to do it for each table as stated in the documentation.

Re: quick way of exporting tables? [Re: -Fusion-] #283765
02/23/2005 6:26 AM
02/23/2005 6:26 AM
Joined: Jun 2001
Posts: 363
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 363
uk
Ah bugger.
Thanks mate.


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,208
Joined: July 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,466
Posts293,522
Members13,801
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,947
Greg Hard 5,533
Top Posters(30 Days)
isaac 1
Today's Statistics
Currently Online 752
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 11
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Snapshot build 20181115.dev)
PHP: 5.4.45 Page Time: 0.033s Queries: 15 (0.009s) Memory: 3.2038 MB (Peak: 3.4067 MB) Data Comp: Zlib Server Time: 2018-12-12 01:02:48 UTC