CODEWITHSUNDEEP
phpsqlinsert
Doctype Designer
Doctype Designer

Reputation: 69

Inserting a phpmyadmin sql dump without phpymadmin

I'm moving a site that had access to phpmyadmin to one where I don't (not yet anyway). Is there a php script to import the generated .sql file into a database? The db is created and ready, just need to import the tables and records.

Upvotes: 0

Views: 1943

Answers (3)

Tanoro
Tanoro

Reputation: 869

Try this.

Upload your SQL file to the web space via FTP and execute a page with this code in it.

<?php
$file="path/to/file.sql";

$command = "mysql -u $dbuser --password='$dbpassword' --host='$sqlhost' $dbname < $file";
exec($command);
?>

Don't forget to set the variables for database name, username, and password. Also, make sure PHP has access to execute commands using the exec function.

Upvotes: 3

goluhaque
goluhaque

Reputation: 571

Use SSH. Install PuTTy first. Ask your host the server IP, username and password for SSH server, and then do the work. Anyway, how do you think you are going to properly manage your tables and databases without phpmyadmin or any other alternative SQL client, eh? Ask your hosts to install them. Btw, looks like your host's at Antarctica or some other ancient place. I mean, come on man, a SQL client like phpMyAdmin is offered even in free subhosting.

Upvotes: 0

marto
marto

Reputation: 4503

Why use php, why not use MySQL itself:

http://dev.mysql.com/doc/refman/5.5/en/mysql.html

Upvotes: 1

Related Questions