My chapter finally sprung for it's own hosting service so I'm moving what I currently have done to its new home. Question of the day....how?
I've done some searches and I must be using the wrong search terms because I cannot find anything detailed.
I have SMF 1.1.2 and the latest version of TinyPortal (w/ Enterprise theme) installed on my "test" site. I've made two backups cause I don't know which one I will need
- First is "save table data"
- Second was both options..."save table data" and "save table structure"
The new site (http://www.ussriverside.us) will be using SMF 1.1.2 and TinyPortal as well. Should I do fresh installs of SMF/TinyPortal first? Do I install mods after that and then import the database?
Help.
http://www.tinyportal.net/index.php?topic=5269.0
IchBin, thanks for the quick response.
So far everything you pointed me to just has me saving all the files and then reuploading them to the new site. Is that correct?
BTW, I've already completed step 1 on that mega guide....maintenance mode. I'm so proud of myself!
Thats all you need to do to move your files. Once you're files are in place its just a matter of importing your database so you don't lose pots/members etc.
1: Export your database via phpmyadmin.
2: Download all you files from the old server.
3: Upload all files.
4: Import the old db into the new one.
5: Run repair_settings.php (Available from SMF on a search).
6: Check all your themes to make sure the paths are correct for images, etc.
I've completed steps 1-3. Moving onto step 4.
Stuck on step 4. Did you honestly think I was smart enough to do it without asking questions?!
My problem is this. I'm using a different database name so I'm getting an error:
SQL query:
# ==========================================================
#
# Database dump of tables in `bkfam93_ussriver`
# February 14, 2007, 03:26:24 PM
#
# ==========================================================
#
# Table structure for table `smf_attachments`
#
DROP TABLE IF EXISTS `smf_attachments`
MySQL said: Documentation
#1046 - No database selected
Help a dumb man out please?!
If you can't import it through the phpMyAdmin. Try this little tool.
Restore/Backup script SMF
http://www.simplemachines.org/community/index.php?topic=18350.0
It will only take you a couple times of doing this before you understand it clark. :) Been there done that.
Make sure you select the database in the left column of phpMyAdmin. Then goto the import tab and insert your database file. Or you can try my above post first. :)
Got it, IchBin, the great I am!
i was finally able to import. I used the repair_settings.php file and maybe more should be told about it. I thought I was done when I saved the settings the first time until I scrolled down and noticed more things that needed changed. Also I didn't see much explanation on queryless url's. I just used the recommended option.
Although I did all that, it still had a few issues with the theme but that was quickly fixed once I went into the admin.
Thanks again for all your help.
I'm still having trouble with some modules such as the location mod and the joined date mod. For some reason, when looking at individual posts, there are two instances of each.
When I look in the forum error log, I get this:
http://www.ussriverside.us/index.php?action=pm
Apply Filter: Only show the errors with the same message
Database Error: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
File: /home/www/ussriverside.us/Sources/PersonalMessage.php
Line: 381
I will take a look at it again. But I'm on my linux laptop, which I normally don't use for coding. If I can find a good editor I should be able to fix it. :)
It appears part of the problem is that the database is kinda funky. i don't know if that's cause of the transfer or what. tables are in latin and database is utf8. i guess this is causing the error.
i do have another question for you and i was hoping you would help me but wondering if i should just pm you about it.
I don't mind if you post or PM. What ever you think is best.
just to let you know, the new site is http://www.ussriverside.us
Well, you had the same problem at the old adress. This is confusing me.... Are you still having this problem? You have to manually edit each table and make them all the same collation. You can't have a mix of collations.
yes, i'm still having the problem. it must have been because i transferred it with the mistakes still in it. :-\
messed this one up didn't i? i didn't know i had such problems with the database otherwise i would have fixed it first. should i switch to utf8 instead of the latin? isn't there a query that would change all tables at once?
I'm sure there's a query to do this, but I don't know it. :( Let me see if I can find someone who does. :)
Here's the command, but you have to run it on each table that doesn't have utf8 set as the collation.
QuoteALTER TABLE table_name_here CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Here's the index.template.php file with the code changes for the mysql/php etc. buttons. I have no way to test this so make a backup of your original file before trying this. Not even sure how it will look. The images you need to have named like this:
valid-css.gif
valid-xhtml10.gif
powered-php.gif
powered-mysql.gif
And they need to me in your themes images directory.
I used the command that you gave me and changed all tables. What's weird is at the bottom where it totals everything up, it still uses the latin collation.
I've attached a text document of what my tables look like. I know it's not the best method but didn't know how else to do it.
I used the index file you modified for me. Here's a file of what it looks like. Broke the theme a tad bit.
I already have the images in my theme folder. Wouldn't it be reasonable to assume that it should be getting the information from the default theme?
does anybody have any idea why this is happening?