Working on a Site Locally

[wickedstangs]

If the database is large, it'd be easier to use the command line to import it.
If not, you'd need to increase the php file upload limits to import via phpmyadmin

won't let me go higher than (Max: 8,192KiB)

 

[AdamD]

How large is your database?
I think if it's a big one, you'll need to do it via command line
http://stackoverflow.com/questions/14846879/import-sql-file-by-command-line-in-windows-7

 

[Paul B]

I use shell for importing my site db to xampp.

mysql -uroot -proot db_name <db.sql

 

[wickedstangs]

How large is your database?
I think if it's a big one, you'll need to do it via command line
http://stackoverflow.com/questions/14846879/import-sql-file-by-command-line-in-windows-7

do I put the .sql file in the bin file location? Then run the command line shown?

 

[Paul B]

Put it in /xampp/htdocs, rename it to db.sql, then run the command I posted above.

 

[dawg]

Very Cool, I got it to work.. Now how do I upload a database on phpmyadmin

I would recommend Sypex dumper. My database is 15 gigs and it dumps it in a matter of minutes no problem.

 

[wickedstangs]

Put it in /xampp/htdocs, rename it to db.sql, then run the command I posted above.

tried it not sure I am doing it right..

 

[Paul B]

Your shell session should be C:\xampp\htdocs.

 

[wickedstangs]

Your shell session should be C:\xampp\htdocs.

 

[wickedstangs]

I use shell for importing my site db to xampp.

mysql -uroot -proot db_name <db.sql

My mistake, I was using the CMD instead of the Shell from XAMPP Control Panel I got the below error for root and root..

 

[Paul B]

You need to use the correct user and password.

 

[wickedstangs]

You need to use the correct user and password.

I did it without the password and it seems to be working..

 

[Paul B]

The -u is the user, followed by the user name, in my case root.
The -p is the password, followed by the password, in my case root.
The db_name is the name of the database.
The db.sql is the name of the backup you are importing.

So if your user name is bob and your password is moo and you are importing a dump named daily_backup.sql into a database named wibble, the command would be:

mysql -ubob -pmoo wibble <daily_backup.sql

 

[wickedstangs]

The -u is the user, followed by the user name, in my case root.
The -p is the password, followed by the password, in my case root.
The db_name is the name of the database.
The db.sql is the name of the backup you are importing.

So if your user name is bob and your password is moo and you are importing a dump named daily_backup.sql into a database named wibble, the command would be:

mysql -ubob -pmoo wibble <daily_backup.sql

Ok, I got that @Brogan and thank you with the assistance, Now for the Collation when creating a backup what would I put?

 

[Paul B]

I always use utf8_general_ci when manually creating a DB.

 

[wickedstangs]

I always use utf8_general_ci when manually creating a DB.

ok everything looks good I am further along now but, it wont see the db when I create it?

 

[wickedstangs]

I always use utf8_general_ci when manually creating a DB.

Ok, I got it to work.. Awesome.. I just noticed the SMF db Collation is latin1_swedish is that going to be a problem? Can it be converted..

 

[wickedstangs]

Not directly, you need to extract it first.
Copy the ftp files and also upload the database on phpmyadmin.

ok I got the database to work how to ftp the files and run the software?

 

[wickedstangs]

@ everyone that helped me.. I did it.. Awesome now I am need to learn to upgrade it to Vb then Xenforo....
localhost/stangfix/index.php

 

[wickedstangs]

@Brogan or anyone I just install vB and trying to do Import using Impex I get this error:

Warning: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in....\impex\db_mysql.phpon line138

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
                        errorid bigint(20) unsigned NOT NULL auto_increment,
                        errortype varchar(10) NOT NULL default '',
                        classnumber varchar(3) NOT NULL default '',
                        importid bigint(20) NOT NULL default 0,
                        error varchar(250) default 'NULL',
                        remedy varchar(250) default 'NULL',
                        PRIMARY KEY (errorid)
                    ) TYPE=MyISAM

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

mysql error number: 1064

Date: Monday 21st 2014f July 2014 04:13:29 AM
Database: vbstangfix_forum
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9