| View previous topic :: View next topic |
| Author |
Message |
ThatGirl4634
Joined: 20 Nov 2002
Posts: 13
Location: My computer
|
 Posted: Thu Feb 06, 2003 12:19 am Post subject: |
 |
|
| Code: | # phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Feb 03, 2003 at 04:44 AM
# Server version: 3.23.54
# PHP Version: 4.2.3
# Database : `dreaming_thatgirl`
# --------------------------------------------------------
#
# Table structure for table `b2categories`
#
CREATE TABLE b2categories (
cat_ID int(4) NOT NULL auto_increment,
cat_name tinytext NOT NULL,
KEY cat_ID (cat_ID)
) TYPE=MyISAM;
#
# Dumping data for table `b2categories`
#
INSERT INTO b2categories VALUES (1, 'General');
# --------------------------------------------------------
#
# Table structure for table `b2comments`
#
CREATE TABLE b2comments (
comment_ID int(11) unsigned NOT NULL auto_increment,
comment_post_ID int(11) NOT NULL default '0',
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default '',
comment_author_url varchar(100) NOT NULL default '',
comment_author_IP varchar(100) NOT NULL default '',
comment_date datetime NOT NULL default '0000-00-00 00:00:00',
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default '0',
PRIMARY KEY (comment_ID)
) TYPE=MyISAM;
#
# Dumping data for table `b2comments`
#
|
then is has all m comments and later on all my posts and stuff, so i have no clue why i don't have any posts or archives.
_________________
the best siggy ever made was the blank siggy. |
|
| Back to top |
|
 |
macshack
Joined: 17 Jul 2002
Posts: 1204
Location: Phoenix, Az
|
| Posted: Thu Feb 06, 2003 1:21 am Post subject: |
|
|
Hi,
Great. This is what I was hoping for. This is a dump of the data from your previous host and includes the create for each of the tables and the data that is to be inserted.
From what your saying, your new host most likely did not do the upload of the data. They may have thought they did but I bet they had an error because of the creates.
In any event, your options are these:
One, have your new host drop the current tables and take you "saved" file and upload those to the database, creating the tables and populating them.
One other options is for you to do it. But if you're not familiar with mysql or phpmyadmin (great tool) then you probably should have your new host do it.
There is no reason why the data that you have needs to be modified in any way.
_________________
Kind Regards,
Michael e |
|
| Back to top |
|
|
ThatGirl4634
Joined: 20 Nov 2002
Posts: 13
Location: My computer
|
| Posted: Fri Feb 07, 2003 12:49 am Post subject: |
|
|
Thanx, I'll get her to do that right away! I'll be posting the results (hopefully they're good)
_________________
the best siggy ever made was the blank siggy. |
|
| Back to top |
|
|
ThatGirl4634
Joined: 20 Nov 2002
Posts: 13
Location: My computer
|
| Posted: Mon Feb 17, 2003 8:29 pm Post subject: |
|
|
Sorry for not posting right away but we still can't get it to work. AH It's killing me, i have no clue what to do now because I REALLY don't wanna lose all my archives.
_________________
the best siggy ever made was the blank siggy. |
|
| Back to top |
|
|
scarbittenross
Joined: 17 Nov 2002
Posts: 22
Location: Ayr, Scotland
|
| Posted: Sun Jul 06, 2003 4:44 pm Post subject: |
|
|
I did everyting you've said to do in this post, but getting this error:
Warning: mysql_connect(): Access denied for user: 'user@localhost' (Using password: YES) in /home/bitten/public_html/b2-include/b2functions.php on line 37
Can't connect to the database server. MySQL said:
Access denied for user: 'user@localhost' (Using password: YES)
Any ideas?
_________________
[w] http://www.scarbitten.co.uk
[quote] " Remember, today is the tomorrow you worried about yesterday." |
|
| Back to top |
|
|
scarbittenross
Joined: 17 Nov 2002
Posts: 22
Location: Ayr, Scotland
|
| Posted: Tue Jul 08, 2003 1:18 pm Post subject: |
|
|
| scarbittenross wrote: | I did everyting you've said to do in this post, but getting this error:
Warning: mysql_connect(): Access denied for user: 'user@localhost' (Using password: YES) in /home/bitten/public_html/b2-include/b2functions.php on line 37
Can't connect to the database server. MySQL said:
Access denied for user: 'user@localhost' (Using password: YES)
Any ideas? |
Its worked out 
_________________
[w] http://www.scarbitten.co.uk
[quote] " Remember, today is the tomorrow you worried about yesterday." |
|
| Back to top |
|
|
bellascritto
Joined: 12 Apr 2003
Posts: 11
|
| Posted: Sun Jul 27, 2003 10:46 pm Post subject: Thanks |
|
|
| Wow this is a great post. I'm getting a domain soon, so I'll be switching my blog, and I was about to post how to switch, when i saw this post. Thanks! |
|
| Back to top |
|
|
amities
Joined: 25 Jul 2002
Posts: 5
|
| Posted: Tue Jan 06, 2004 8:58 am Post subject: |
|
|
| Hello, I have a problem with regards to exporting my database. I use accents, e.g., é, ü, etc., and so when I exported my database and then imported it to my new host, the accents have been changed, i.e., my ç have become Á. How do I prevent this, if I can prevent this? |
|
| Back to top |
|
|
Serveza
Joined: 13 Oct 2003
Posts: 7
Location: Canada
|
| Posted: Thu Jan 08, 2004 6:32 pm Post subject: Importing from phpMyAdmin |
|
|
Hello,
So I'm trying to switch the folder that my b2 is installed in. I thought exporting and re-importing would help...
I've exported the database, but how do I import? Do I have to delete the old database first, then re-create it and then will it give me the option to import the .sql file?
Or do I not have to do any of this and, as it's on the same server just under a different folder, I just have to move the b2 files? *so confused*
Any help would be appreciated! |
|
| Back to top |
|
|
Cyberian75
Joined: 26 Sep 2002
Posts: 1278
Location: Oregon
|
| Posted: Thu Jan 08, 2004 7:14 pm Post subject: Re: Importing from phpMyAdmin |
|
|
| Serveza wrote: |
Or do I not have to do any of this and, as it's on the same server just under a different folder, I just have to move the b2 files? *so confused*
|
That's correct.
_________________
Michael P.
 |
|
| Back to top |
|
|
Serveza
Joined: 13 Oct 2003
Posts: 7
Location: Canada
|
| Posted: Thu Jan 08, 2004 7:35 pm Post subject: |
|
|
| Yay! That was so incredibly easy Now I'm beginning to see the power of MySQL databii |
|
| Back to top |
|
|
sarah_kabam
Joined: 28 Sep 2003
Posts: 9
|
| Posted: Sun Sep 12, 2004 10:29 am Post subject: help!!! |
|
|
i get this after i try to import!!
| Code: | Error
SQL-query :
CREATE TABLE `b2categories` (
`cat_ID` int( 4 ) NOT NULL AUTO_INCREMENT ,
`cat_name` tinytext NOT NULL ,
KEY `cat_ID` ( `cat_ID` )
) TYPE = MYISAM AUTO_INCREMENT =13
MySQL said:
#1050 - Table 'b2categories' already exists |
huhuhh!! |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
