FusionBB

Please See the FusionBB End Of Life Announcement

FusionBB Review (large)
FusionBB SWAG!

FusionBB golf shirts, t-shirts, mousepads and more.

Tagging
 Page 2 of 2 All<12
Username Post: 1.1 Import Data        (Topic#4109)
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-07-06 10:44 PM - Post#38909    


    In response to smilesforu

Oh Oh... I hope it wasn't a bug on our part?
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
JoshPet
FusionBB Developer
Total Posts: 6726
*
Birthday: 02-08 
Location: Charlotte, NC
Average Post Ranks%:                       
 
12-07-06 10:50 PM - Post#38911    


    In response to Dave

I fixed him. His database got changed in his config file.



Feel Better, Feel Younger, Sleep Better - Trans-D Tropin
Visit www.BuyTransD.com - use coupon code 1004 to save $20


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-07-06 10:57 PM - Post#38912    


    In response to JoshPet

Was it a bug on our part though? Did the config file not get updated correctly?
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
JoshPet
FusionBB Developer
Total Posts: 6726
*
Birthday: 02-08 
Location: Charlotte, NC
Average Post Ranks%:                       
 
12-07-06 11:16 PM - Post#38914    


    In response to Dave

Yeah, all was fine. I think he was trying to use a secondary database which didn't have fusion tables.



Feel Better, Feel Younger, Sleep Better - Trans-D Tropin
Visit www.BuyTransD.com - use coupon code 1004 to save $20


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-07-06 11:34 PM - Post#38917    


    In response to JoshPet

I'm not sure I follow. He was importing to tables other than the tables fusion was installed to? That shouldn't be possible?
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
JoshPet
FusionBB Developer
Total Posts: 6726
*
Birthday: 02-08 
Location: Charlotte, NC
Average Post Ranks%:                       
 
12-08-06 12:02 AM - Post#38918    


    In response to Dave

No I think he just changed the name of his database from the admin area to a database that didn't exist.



Feel Better, Feel Younger, Sleep Better - Trans-D Tropin
Visit www.BuyTransD.com - use coupon code 1004 to save $20


 
smilesforu
maximus
Total Posts: 147
*
Birthday: 10-15 
Location: NW WA
Average Post Ranks%:                       
12-08-06 12:17 AM - Post#38920    


    In response to JoshPet

it was me I was trying to use what I thought was a backup of my current threads database and it timed out doing the import and since I couldn't see any changes in the fusion I tried switching database addresses, which locked me out... doh

I need to try from a backup database of my current threads, but I don't have the skill to backup that database to try it. It is a fairly large database and since I screwed up some stuff on the site lately I need to try it from a backup and get stuff setup before going making the full switch.
Marty


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-08-06 12:22 AM - Post#38921    


    In response to smilesforu

If you have ssh access issue this from the command line:
mysqldump -u YourDBuserName -p YourDBname > YourDBname.sql

You'll be prompted for the db user's password.

After it's finished you can import it to your test database:

mysql -u YourTestDBuserName -p YourTestDBname < YourDBname.sql



You may want to tar/compress that sql file with:

tar cfz YourDBname.sql.tar.gz YourDBname.sql


Then download that to your computer.
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked




Edited by Dave on 12-08-06 12:25 AM. Reason for edit: ack.. tar cfz, not xfz (latter decompresses)
 
smilesforu
maximus
Total Posts: 147
*
Birthday: 10-15 
Location: NW WA
Average Post Ranks%:                       
12-08-06 01:30 AM - Post#38922    


    In response to Dave

I am only looking to make a backup so I can use that for my test board. Need to iron out the wrinkles before I import live.

ON vertex but don't see ssh in the control panel
Marty


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-08-06 01:39 AM - Post#38923    


    In response to smilesforu

You probably don't have ssh access then.
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
smilesforu
maximus
Total Posts: 147
*
Birthday: 10-15 
Location: NW WA
Average Post Ranks%:                       
12-08-06 06:25 PM - Post#39020    


    In response to Dave

How do I know if the importer is working. I have tried several times to import and when I check the fusionbb database it hasn't moved any posts.

It does say I lose connection but thats after 50-100 screen refreshes.
Marty


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-08-06 08:34 PM - Post#39025    


    In response to smilesforu

It should say where it's at, such as 1500 to 2000 users.

If you can send me login/ftp info for your site and let me know what the database is your using then I can see if I can figure out what's going on.
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
JoshPet
FusionBB Developer
Total Posts: 6726
*
Birthday: 02-08 
Location: Charlotte, NC
Average Post Ranks%:                       
 
12-08-06 11:57 PM - Post#39050    


    In response to Dave

I've got his info dave and will check it out. He's already got a database copy in the forum2 database. So he shouldn't need to worry about making a copy.



Feel Better, Feel Younger, Sleep Better - Trans-D Tropin
Visit www.BuyTransD.com - use coupon code 1004 to save $20


 
Dave
FusionBB Zealot
Total Posts: 8913
*
Location: Iola, Wisconsin
Average Post Ranks%:                       
12-09-06 12:09 AM - Post#39053    


    In response to JoshPet

Sounds good. He PT'd me his info already but I haven't gotten to it yet.
Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked


 
 Page 2 of 2 All<12
Icon Legend Permissions & Sharing Options Topic Options
Print Topic


20393 Views
Calendar
SMTWTFS
 123456
78910111213
14151617181920
21222324252627
282930 
Current Quote
"FusionBB is to the on-line Bulletin/Message software business, the BENCHMARK on which all others will have to measure up to in the future if they are to remain in the game."
~ sam_w
FusionBB™ Version 3.2 | ©2003-2014 InteractivePHP, Inc.
Execution time: 0.197 seconds.   Total Queries: 258   Zlib Compression is on.
All times are (GMT-4). Current time is 06:50 AM
Top