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


20449 Views
Calendar
SMTWTFS
 123456
78910111213
14151617181920
21222324252627
282930 
Current Quote
"This private topics idea... Genius! It already seems better than most of the competitors."
~ Jason
FusionBB™ Version 3.2 | ©2003-2014 InteractivePHP, Inc.
Execution time: 0.12 seconds.   Total Queries: 258   Zlib Compression is on.
All times are (GMT-4). Current time is 02:20 AM
Top