67 replies to this topic

[Martin]

To import the database you have three options. First one is using PMA, which in your case didn't work.
The second one is using "mysql" in command line, this method is the one I prefer. That way you only have to worry about one application, not three (Apache, PHP & MySQL). And it's therefor not much that can go wrong.
The last on is using yet another 3rd party app. This one i called BigDump. Many people have used it, and it worked for them. To me, and my 1.6GB database it didn't. But with only 15MB to handle it should be no problem. Give that a shot before trying to do it in command line, which I soon will explain.

To use bigdump just place the SQL file and bigdump.php in your htdocs folder, and do the needed changes to bigdump.php. Most of the variables are greatly explained, so that shouldn't be any problem. Then run bigdump.php in your web browser, and it should take care of the rest.


Using mysql in command line is a bit more complicated.
To make the process a bit easier, copy your database file to C:\xampp\mysql\bin\.
Type "cmd" in Start->Run (Win+R), then run the following commands

cd c:\xampp\mysql\bin

mysqlimport --user=user_name --password=password database file_to_import.sql

Your database should now be fully imported, if you don't get any errors during the last step.


To rename the database you can do this in PMA. Select the database you wish to rename, then select the "Operations" tab. There should be a field saying "Rename database to:", then just type in the new name. You should do this step before importing the backup, just to save some load.


The reason why your public host just have one single file, and localhost has three, is because the database at your host is running on the InnoDB engine, while localhost is on MyISAM. You have the option to choose between those two when creating a table.


-Martin

[Sandi]

Already tried bigdump and it doesn't work:

Error at the line 10: ) ENGINE=MyISAM AUTO_INCREMENT=171 DEFAULT CHARSET=latin1;

But both databases are "latin1_swedish_ci"

I will give mysql in command line a try. It doesn't look that complicated if I'm careful.

And thanks for the info on renaming the db. I will let you know how the command line import turns out.

[Sandi]

Ok it almost works Martin. At least it appears to be importing the db (see below), but I'll be darned if I can find what it did with it. It doesn't show up in the PMA db list. Because I can't copy from a CMD, below is a snapshot of the import.



BTW I used my PMA user/password, not for the db which I assume was correct.

*So close now I can almost taste victory*

Edit to add: I had to remove database (shown in bold) as it thought that was the database name.

mysqlimport --user=Sandi --password=******** database ibf_dbbackup.sql

Edited by Sandi, 11 April 2008 - 01:32 AM.

[Sandi]

Success!

I finally got it done with BigDimp. I found the previous bigdump problem that was causing the language incompatibility. However I had to remove the following comment lines from the end of the db file using Notepad++ (the only thing that I can find that will read db files).

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

It passes DB checks in APC except one. I now have all of my members and mods working on my localhost. The one remaining problem that I am not going to worry about right now is that some of the skins have the wrong ID. I can probably manually edit those later.

[KelF]

I have an issue.

I did all of the SQL stuff correct, I type my SQL username, DB username and username password, and this is what I get in return:

Quote

Warning: Access denied for user 'Sky'@'localhost' (using password: YES)

How nice. Can someone help me please?

[AndyF]

Your SQL details are wrong (username / password)

Try leaving the password field blank for the moment and try it again.

[KelF]

I fixed it myself, thanks for your reply anyway Andy.

[Charles C]

I just installed 3.0 via Xampp on OS X, and received this error: "Could not determine your IP address", any help would be greatly appreciated.

[Martin]

From what I've read on the IPS forums during the beta period, OSX use IPv6, and IPB doesn't support that.

Adding the following to conf_global.php should work

$_SERVER['REMOTE_ADDR'] = '127.0.0.1';

[Charles C]

Perfect, thanks.

[riven3d]

ok that fixed it for 3.0.

but im trying install lower versions on the local host to work with and im getting the same problem, since the forum isnt even installed yet, no conf_global file to work with

[maruf]

Ok, I have an issue Since I have Oracle installed on my machine, I changed HTTP port from 80 to 81 and HTTPS from 443 to 4499 and the Apache server started fine but the web browser failed to connect to http://localhost/xampp. It gave me a website not found error message. Then I used a different HTTP port, 2244, but still the web browser cannot connect to http://localhost/xampp. Why is http://localhost/xampp not reachable?

[riven3d]

do you have a directory in htdocs for xampp?

[maruf]

Yes, I do.

[Martin]

If you change the port number, you have to use "localhost:PORT" instead of just "localhost", which will always go to port 80.

[maruf]

m4rtin, on Oct 22 2009, 02:47 AM, said:

If you change the port number, you have to use "localhost:PORT" instead of just "localhost", which will always go to port 80.

You mean in the browser I have to type, http://localhost:2244/? I did this just now but didn't work.

[maruf]

Finally! it worked I had to clear the browser caches to get it working. Thank you, M4rtin

[Martin]

Glad you got it working

[maruf]

Now, I am trying to install ipb board on my local and I typed http://localhost:2224/ipb30/ in the browser, but the installer didn't work. It just showed the parent and upload directory. When I added install.php at the end of the above url, it gave me a 'object not found' error (404) message. So, how should I go about installing the forum? Thanks in advance,

[Martin]

If you click on the "upload" folder in your browser, I'm pretty sure you'll see the installer.

You want to move the content of "upload", not the folder itself, into "ipb30".