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

Joined: Jun 2001
Posts: 356
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 4:50 PM
02/22/2005 4:50 PM
Joined: Dec 2000
Posts: 1,471
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,471
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 5:15 PM
02/22/2005 5:15 PM
Joined: Jun 2001
Posts: 356
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 356
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 4:53 AM
02/23/2005 4:53 AM
Joined: Dec 2000
Posts: 1,471
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,471
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 5:11 AM
02/23/2005 5:11 AM
Joined: Jun 2001
Posts: 356
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 356
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 5:26 AM
02/23/2005 5:26 AM
Joined: Dec 2000
Posts: 1,471
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,471
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 7:26 AM
02/23/2005 7:26 AM
Joined: Jun 2001
Posts: 356
uk
M
monkeyra Offline OP
Junior Member
monkeyra  Offline OP
Junior Member
M

Joined: Jun 2001
Posts: 356
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
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,779
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,482
Posts293,586
Members13,811
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 21,084
JoshPet 10,370
LK 7,395
Lord Dexter 6,709
Gizmo 5,779
Greg Hard 4,625
Top Posters(30 Days)
driv 19
isaac 17
Gizmo 6
Today's Statistics
Currently Online 908
Topics Created 0
Posts Made 0
Users Online 2
Birthdays 19
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190304.dev)
PHP: 5.4.45 Page Time: 0.039s Queries: 15 (0.009s) Memory: 3.2211 MB (Peak: 3.4174 MB) Data Comp: Zlib Server Time: 2019-03-20 09:24:09 UTC