Alright, so I am incredibly new to mysql and command line stuff and I’m trying to feel my way through all of this.
Basically, I’m in the process of converting my invisionfree forum over to SMF, which I am hosting with dreamhost. I received my database dump from IF and am trying to get it uploaded into my database.
I was given the following instructions:
[quote]Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
or you can use these queries:
DELETE FROM ibf_badwords; DELETE FROM ibf_posts; DELETE FROM ibf_calendar_events; DELETE FROM ibf_categories; DELETE FROM ibf_contacts; DELETE FROM ibf_emoticons; DELETE FROM ibf_forums; DELETE FROM ibf_groups; DELETE FROM ibf_members; DELETE FROM ibf_messages; DELETE FROM ibf_moderators; DELETE FROM ibf_polls; DELETE FROM ibf_stats; DELETE FROM ibf_titles; DELETE FROM ibf_topics; DELETE FROM ibf_tracker; DELETE FROM ibf_voters; DELETE FROM ibf_cache_store; DELETE FROM ibf_forum_perms; DELETE FROM ibf_topic_mmod; DELETE FROM ibf_validating;
Then run the queries in the file you downloaded. See http://dev.mysql.com/doc/mysql/en/batch-commands.html[/quote]
I got through most of that until the very end with the link to batch-commands. I downloaded PuTTY and have been trying to use that, but I’m a bit lost. After successfully connecting with my…domain? I tried using the command:
But that just returns the following error: [quote]Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’[/quote]
I have a feeling that I’m in the wrong mode or I was supposed to do something else first which is why I’m having that problem. Help please? I’m kind of clueless.