96than
Nov 9 2006, 10:37 PM
| | i have just got hosting here on astahost and i have to copy my databases from my old server...
is there an easy way of doing this? in phpmyadmin?
thanx in advance you know lol 
|
Reply
TavoxPeru
Nov 10 2006, 05:03 AM
QUOTE(96than @ Nov 9 2006, 05:37 PM)  i have just got hosting here on astahost and i have to copy my databases from my old server... is there an easy way of doing this? in phpmyadmin? thanx in advance you know lol Yes, you can do this with phpmyadmin, you can do it with the import option if you first export your database as a sql file, take care with your databases charsets and versions, you can found some trouble with it. Best regards,
Reply
jlhaslip
Nov 10 2006, 05:08 AM
Phpadmin would work, yes. Export the database structure and content from the source and then Import it into the Target at the new location. You might also consider that the structure and data could be Exported / Imported seperately. That would let you define the databases first before adding the data. I might suggest you do a test run, set up the database and site at the new location before you actually delete anything at the original location.  *stuff happens* If you need any further direction, post back here and somone will assist you.
Reply
96than
Nov 10 2006, 09:50 AM
thanx guys i didnt know it was that easy lol i have moved the databases now and its all working
Reply
Similar Topics
Keywords : copy, databases, phpmyadmin
- Databases
(2)
Free Graphical Tools For Databases
(7) There are a lot of different free software in Internet, but I have found only couple of free
graphical tools for database adminiatration. On another hand, MySQL is free for non commercial
usage. That's way it will be nice to have any good free GUI for this database. I remember the
time, when one of MySQL-Front versions was for free, but now it is opened only for testing period.
There is also free version of Toad, which is not full Toad, but it looks also very well - However, I
am not going to use Oracle (wchich is quite expensive commercial tool) on my desktop. The....
All About Databases
Info, for you! (3) QUOTE Hi, I noticed there were a lot of questions in all of the database topics, so i went
around the internet using different sources, and have some information that will answer your
questions and help you understand databases. I hope this helps, and if you have any other questions
which arent answered below, please send a message asking. Thankyou. In computing, a database can be
defined as a structured collection of records or data that is stored in a computer so that a program
can consult it to answer queries. The records retrieved in answer to queries become i....
Phpmyadmin Export And Collation Problems
(4) I have a very strange problem with the Exported sql file generated by phpMyAdmin that never happen
to me before, the problem is that my data contains some strange characters but when i see them on
screen it shows correctly, instead of showing the spanish characters á, é, í, ó, ú and ñ it shows
others, for example instead of á shows á, instead of ó shows ó, etc. The other problem i have is
that when i use Internet Explorer and want to download the generated sql file to my machine nothing
happens, it seems that the export script works completely but it never shows the S....
Examining Databases At A Whole Glance
SQL-92 specification (7) Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly
these days. SQL-92 specifiaction is the SQL database query language standard. Oracle,mysql
postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to
SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification
features inside in the program. Implementation of SQL-92 specification features are applied in the
order of Oracle, postgresql and mysql. These databases might have specific database query....
How Do You Make Large Databases?
(14) In a game I'm working on, I would like to have a database of actors/actresses. I'm not sure
exactly how to do this. I'm pretty sure with the hosting here, I can only have 99 databases.
I'm a little lost as to how to make it. Can all the actors/actresses be put on one database
with the specific things I want to include (i.e. how well the do in each genre)? I'm new to
Mysql and just need some help as to where to start.....
Ms Databases
(6) Hello, I can make my own MS Access database, but can anyone tell me how to make a password gate
that checks the user info with the database? Olie122333 /biggrin.gif"
style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
Can You Make Your Own MySQL Databases?
Im an idoit (7) Can you make your own MySQL database or do they have to be bought or found from a free site i really
need help on this guys please reply or send me a PM when you have the time because i need so much
help with this atm /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif"
/> thankyou very much regards Morex Gaming owner Jarvis....
How To Setup SMF Databases?
(4) does anyone know how to set up a database for a SMF forum.....
What Is A Database How Do I Use One?
: Information about Databases and how to get use them efficiently (7) Hello All Let's start off by talking about what a database is and how it would be efficient
in using it. It wasn't until about a year and half ago now that I was first introduced to this
new age of Database. I discovered a lot of neat things and even learned about databases the very
long way. A database is exactly how it sounds its data that has a base. The base being the place
where you store all your data. If you have ever been to a library perhaps you have used the Index to
search for an author, this is a database of authors. Ever seen a rolodex on someo....
How To Use MySQL/phpMyAdmin Under Linux
Web Development (5) Can any anybody help me by guiding me on how to use mysql database, creating tables and showing
database results using Phpmyadmin in a Linux Web Hosting ?....
Updating A Database's Tables
(10) Is there an "easy" way to update a database's tables? Like for instance, I have my own
custom-coded member login system. Whenever I add a new feature that needs a database, I manually
have to download, update and upload the database. Is there an easy way I can do this?
THANKS!!! F....
Combining Databases
Please help before I mess up! (4) I am intergrading this Private Messaging system into my website so that my members can login and
access their PMs through the seprate PM software without loging in twice and registering twice since
if I left it as is, that is what they would have to do... All I really need is 1 single table to be
combined without damaging my few member's accounts (they are all friends, but I don't want
to tell them that I was playing with the database and lost your account information...
/rolleyes.gif' border='0' style='vertical-align:middle' alt='rolleyes.gif' /> ) Since I d....
Unexpected Database Crashes
sometimes my astahost databases are down (0) Sometimes some of my astahost databases are down. After a couple of hours or a couple of day they
are up again. Sometimes all of them are down at the same time, sometimes some of them are up and the
other ones are down. The symptom is that when I connect to the forum I have an error message, saying
"Parse error: parse error, unexpected '\"', expecting ',' or ';' in
/home/../../.../../index.php on line 25" It's not an error in my phpbb because it used to work
correctly. So, what happends ? I suppose that the databases crash if the astahost....
Creating Databases
from programs (4) I jsut went throught PC magazine today and i found out that you can actually create a database using
Microsoft Access and Excel. And computers and servers online can actually use these databases and
conduct queries with them. I've always though of databases as MYSQL, Microsoft SQL server and so
on. So it is possible to store data to a Microsoft Access database and manipulate it online?....
Migrating Databases
Migrating from MSSQL Server to MySQL (2) How to migrate my database from SQL Server to MySQL?....
Remote Databases
How to allow remote connections? (4) I am currently in a big-problem. I am trying to use a MySQL database on another host, and I am
hosting my forums, on another host, and I am trying to install the forums but the error that comes,
says that the remote connection canot be allowed. Can anyone help me on how to resolve this issue
and proceed further, or should I just wait for astahost.com to get an account? All suggestions
welcome! /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> ....
phpMyAdmin-MySQL Error #1251:client Authentication
Stupid error (6) After I installed phpMyAdmin and tried logging in with the root password, I get this : #1251 -
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I already installed mySQL administrator and enabled old passwords. Any help would be
appreciated. Oh yeah I have : mySQL version 4.1.11-nt mySQL client 5.04 Apache 2.0.54 PHP 4.3.11
phpMyAdmin 2.6.1-pl3....
Hosting A Server On Database
I'm a total noob at databases (6) Well this might be in the wrong place or I might have no clue what im talking about but I heard
something. Is it possible to host like a .exe server such as a macromedia multiuser server on a
database such as MySQL or any other databases? I have a friend that said he did it but I think he is
lying. Thanks in advance!....
Need Advice On Creating Online Music Database
ps - dont know anything about databases! (6) I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to
use?! Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
Topic edited to reflect content better. ....
The Best Database
databases (41) te best database for my is sql server yukon for you?....
Free Databases
mysql,postgresql,SAPDB,sybase,DB2 (14) this website offers Database hosting for free. Jus signup and u get u r own database .. it supports
mysql, postgresql, sapdb, sybase, db2 CODE http://freesql.org from the webpage QUOTE
This service is, and will remain, totally free. I have receive hundreds of Thank you emails from
all over the world telling me that having this service available has allowed them to practice and
learn without the burden of having to run their own server. ....
Looking for copy, databases, phpmyadmin
|
|
Searching Video's for copy, databases, phpmyadmin
|
advertisement
|
|
