Help me move my smf forum from my old host

[Killaz4Life]

im unable to and my old host (freehostia) was a pain in the ass so i realy need to have my forum moved can anyone help me i had errors when moving the database.

thank you. Killaz4Life

 

[TheMan177]

What are the errors you are getting?

 

[Killaz4Life]

Error
SQL query:

# ==========================================================
#
# Database dump of tables in `leoleo48_smf`
# August 10, 2008, 10:41:48 AM
#
# ==========================================================
#
# Dumping data in `smf_attachments`
#
INSERT INTO `smf_attachments` (

`ID_ATTACH` ,
`ID_THUMB` ,
`ID_MSG` ,
`ID_MEMBER` ,
`attachmentType` ,
`filename` ,
`size` ,
`downloads` ,
`width` ,
`height`
)
VALUES ( 1, 0, 0, 2, 0, 'avatar_2.png', 6948, 1, 65, 43 ) ;



MySQL said:

#1146 - Table 'k4l_smf.smf_attachments' doesn't exist

 

[TheMan177]

Make sure you check the option to backup the table structure.

 

[tittat]

Go to your phpmyadmin, export all database tables(from your previous host).Then import it here at x10 via phpmyadmin.
If you still have problems please don't hesitate to ask.

 

[Killaz4Life]

Go to your phpmyadmin, export all database tables(from your previous host).Then import it here at x10 via phpmyadmin.
If you still have problems please don't hesitate to ask.

i did exactly that but it dosent work

 

[DeadBattery]

Have you taken a look at this:
http://docs.simplemachines.org/index.php?P=1ef82d53de5bfd19a65b99b168d49520&topic=491.0
It looks like you don't even have to use phpMyAdmin to export your database.
Then go into phpMyAdmin at your site hosted at x10Hosting, select the database and click Query.
Paste what you got from exporting it from SMF.
This might also help:
http://docs.simplemachines.org/index.php?topic=489

 

[Killaz4Life]

Have you taken a look at this:
http://docs.simplemachines.org/index.php?P=1ef82d53de5bfd19a65b99b168d49520&topic=491.0
It looks like you don't even have to use phpMyAdmin to export your database.
Then go into phpMyAdmin at your site hosted at x10Hosting, select the database and click Query.
Paste what you got from exporting it from SMF.
This might also help:
http://docs.simplemachines.org/index.php?topic=489

export when fine but the import gives the error

 

[Nathan H]

How are you exporting, and make sure in phpmyadmin that you haveselected to recreate the tables.
What you could try as well is manually recreate the table through phpmyadmin and try importing again, it should complain about it not being there at least

 

[Killaz4Life]

i export using smf and import clicking on a database and clicking import upload the file and theres the error
Edit:
i passed it manualy no need to help me anymore

 

[Nathan H]

*Thread Closed*
The thread starter may re-open the thread if an issue arrises or create a new thread.

(The reason for your problems was that you was using SMF to export your database and not phpmyadmin on your old host)